Skip to main content
User Community
Pyramid
Help
Learning Hub
Support
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Questions & Answers
Explore Pyramid
Product
Events & News
Member Lounge
Latest Activity
Home
Profile
Ian Macdonald
Admin
Ian_Macdonald
VP Product Management
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
1171
posts
418
likes received
16
followers
Badges
2768
33
7
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Publication - Slicers for email and display name
Create a discover view that is the complete set of Names. I.e. a list of names. then use that view in a Dynamic Text and retrieve the first row Name. Link the email slicer to the dynamic Text…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
2
Questions & Answers
Answer
Reported - view
Re: Alert email in PA2018
Available now in V2018.05
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: implementattion of chord chart in pyramid 2018
Hi Manish, As of Pyramid 2018.05.nnn you can add your own visualisations in to Pyramid. We have based the approach on the D3 visualisation library. Thus you can copy the JavaScript from the D3 Chord…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Creating a Moving Annual Average
Good stuff guys! Please be aware though, if you are reading this thread, that this only applies when using SSAS OLAP or Tabular cubes with MDX. This approach using PQL for our In Memory DB or SQL…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Multiple Unions in the same model
Also, if you have multiple text files of the same structure, you can use the "Multifiles" option in Model where Pyramid will cycle around all similarly named files in a specified directory and…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Maintaining Formatting when Exporting to Excel
Hi James, Export to Excel outputs the data content of the Discover view, or in the case of Publish and Present, creates an Excel workbook with the data from each query on a separate tab in raw…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: How to get text output from dynamic text?
Hi Simo, Seems to work for me. See image below. Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Box plot
Hi Ranga, We do not currently offer a Box Plot as a Chart / Visualisation type. However, in the next release of Pyramid 2018, you will be able to create custom visualisations based on the D3…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Standard Deviation
Hi Ranga, Create a set of the weeks you want to calculate the Standard Deviation of using Formulate model. This can be done in a number of ways, creating a dynamic set of weeks (that moves forward…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
1
Questions & Answers
Reported - view
Re: Model - Shared file
Hi @Tim Wilson, In an Active Directory authentication system, the Pyramid Services run under the Local or Network Service for that machine. Thus you will need to give that AD Machine Name access…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Filter values in presentation?
Hi @Simo Leppänen This functionality is available in 2018.04 which should be GA in the next week or so. Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Pyramid 2018 Model - File too big
@Dave Fackler Correct.
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Background member
Yeah, what Yakov said :) Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Background member
Hi Simo, Can you elaborate a bit more? I'm not sure what you are referring to. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Pyramid 2018 Model - File too big
@Dave Fackler - The Runtime and Task Engines are the two Pyrmaid 2018 services that require access to the shared file location.
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Pyramid 2018 Model - File too big
Hi Dave, For the shared file access, I'll check with our support team and get back to you. Meanwhile, I've had a look at the forthcoming 2018.04 release and the file upload limit has been increased…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Grouping of dimension
Hi Nikos, If you are creating the aggregates using the element tree of the dimension, selecting the items you want to group and applying the Aggregate function,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Pyramid 2018 Model - File too big
Hi Missy, When you install Pyramid 2018, by default the file upload size is limited to 100MB. You can change this in the Admin console under Settings/File Upload. The maximum file size is 500MB.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
1
Questions & Answers
Reported - view
Re: Choropleth Maps
Hi Ieva, Many countries are supported to lower levels of geospatial shapes. Here is an example of UK PostAreas. If you are using country specific geospatial shapes, like postcodes etc,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Data Not Current
Rather than ingest data and continually rebuild the model every 2 minutes, you would be better off to use Direct Query against your View and query the database without doing an extract / ingest /…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
1
Questions & Answers
Reported - view
Re: What is initial user when changing provider from DB to AD?
Hi HDT, Your LDAP address should be in the form of: LDAP://DC=subdomain,DC=domain,DC=other,etc. Before you filled in that dialogue box, it would have shown in grey an example in this format.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: What is initial user when changing provider from DB to AD?
Can you post a screenshot of how you have filled in the details for changing to AD authentication?
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: What is initial user when changing provider from DB to AD?
Hi HDT, This will be the Active Directory identity of the user who will provide the continuing Pyramid 2018 configuration. Once you change the authentication provider to Active Directory,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
6 yrs ago
Questions & Answers
Reported - view
Re: Email Distribution for Publication based on Slicer
Hi Rose, Your image shows the email distribution options in BI Office, not Pyramid 2018. In BI Office, if you want automatic email distribution by slicer,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
7 yrs ago
Questions & Answers
Reported - view
Re: Update data from excel file in pyramid 2018?
One more thing... My comments above refer to the Enterprise Edition of Pyramid 2018. The Community Edition does not include the scheduling option. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
7 yrs ago
Questions & Answers
Reported - view
1
19
20
21
22
23
24
25
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Highlights
Product Ideas
Current Product Ideas
Archived Product Ideas
Knowledge Base
Embedding Pyramid
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
Member Lounge
View all topics