-
Dynamic texts for Slicers
Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…
- Answered
-
Switching time hierarchies on dashboard
Hi Folks! Wondering if anyone knows of an easy way to switch time hierarchies on a dashboard. Example is 4 different dates with time intel, Date Born, Date Married, Date Divorced, Date Died.…
- Answered
-
Pyramid 2018.05.4 Released
The May release of Pyramid - build 2018.05.642 - covers numerous bug fixes and several features. Upgrading Instructions and best practice guides on how to run the upgrade can be found here.…
-
Tooltips
Hi, My tool tips don't appear to be working. I have told the software to display the Netlocation as tooltips, but when I scroll over or click on the lines in the line graph nothing appears.…
- Answered
-
How to leverage URL and Email Attributes in Actions
Actions can be used to take advantage of columns that contain website URLs or email addresses. In this sample dataset, I have both features. Actions can be created in the Discover module and in the…
-
Repeat row/column headers in group
Hi All, Is there a way to repeat row/column headers for each row/column in a group? So instead of seeing for example: 2018 once, then each month under, I see 2018 over each individual month? Thanks,
- Answered
-
Sorting Question with Stacked Hierarchies
Is it possible to apply sorting to an inner hierarchy stacked with an outer hierarchy so that the inner hierarchy is sorted while respecting the current member of the outer hierarchy? For example,…
- Answered
-
Dynamic Eliminations
I’ve been trying to do some dynamic eliminations using sets of sets. i.e creating two crossjoined sets (from 2 different dimensions) then making a set of the resulting sets.…
- Answered
-
Problems with Custom Maps
I've been creating some map reports and I have a postcode hierarchy consisting of Country, Area, District and Sector. When in the hierarchy, the shapes don't change as you drill down.…
- Answered
-
Discovery chart - how to show % values to 1dp?
Hi all, In my discovery chart, I would like to show my axis labels to 1 decimal place (they currently show to 3 decimal places). E.g. they show 1.200% when there is really no need.…
- Answered
-
Displaying only yesterdays Date
The data my company collects is a day behind, is there a way to show just the data information from yesterday? Ex: Today is 4/10, the most recent data I have and want to show in the discovery is 4/9?…
- Answered
-
Reg:SAP ERP systems
Hi Team, Can we connect pyramid analytics directly to SAP ERP data source? or do we need to have any connectors?? Thanks in advance.,! Regards, Manish
- Answered
-
Is there a way to create groups and then filter within those groups
My discovery table needs to contain some groups so I can filter by those. For example with countries the data set we use has them broken out, I will need to create a group for all the European…
- Answered
-
De-Duplicating Data Sets with Pyramid
Introduction Following on from my previous blog on de-duplicating records using Python, I was curious to see if I could achieve the same result with some creative use of the standard Pyramid Model…
-
De-Duplicating Data Sets with Python
Introduction There are occasions when it is necessary to de-duplicate records before further transformations are required and before loading into the data model target database server,…
-
Azure Analysis Services
Does anyone here actively use Azure Analysis services? How do you find it?
- Answered
-
GA input call/record limits
Hi all, do you know what the limits are for how many records/days/etc. can be pulled in from Google Analytics at a time? We are only receiving a limited part of the data when pulling from longer…
- Answered
-
OLAP Createating a Calculated member under the Hierarchy
Hello All Can we create a Calculated member under a Hierarchy and add it to a different parent under the same Hierarchy in an OLAP Cube. To give an example Let us assume there are 4 Level for…
- Answered
-
Major Updates to Help for PQL and APIs
A major update to help has been published with extensive documentation for both the PQL query language and the application's REST APIs. PQL The new help for PQL includes an overview of the Pyramid…
-
embedding with php or python
I have seen examples of using the embedding functionality with c#, java, and js/ajax? Does anyone have a example in php or python? Thanks. Kevin
- Answered
-
Enable export themes from BI Office to Pyramid 2018
Can the Pyramid team provide themes for Pyramid 2018 that match the themes that are available in BI Office? In particular, some of the default themes like Pyramid 2013 and Pyramid 2016 would be very…
- Answered
-
Why Are Themes Not Securable Objects?
Given that themes now appear to include features for defining specific master pages for presentations and publications, it would seem helpful to have themes be securable objects so that only certain…
- Answered
-
MODEL: Change stored procedure used to access data on SQL Server.
Hello, I have been testing Pyramid. In a model, we can obtain data from a SQL Server from a table or executing a stored procedure. If I want to use another table,…
- Answered
-
List last FULL month
Hi, I am not sure if I am doing something wrong, but I can't work out how to create a set containing dates from the last full month (so today, I want all dates in February).…
- Answered