-
Union: Adding Attributes to a Node
How do you Map Your Measures? You have numbers accrued in a database or excel for months, but nobody has taken an interest in them. You want to unleash the can of worms, so to speak,…
-
IMDB hangs during install on Linux Centos
We found that in some case when installing Pyramid on Linux Centos, the installer hangs on the IMDB phase. In the current installer 2018.05.642 (5.4) there's a missing switch "-y" that enable the…
-
You don't have access to this Database source
I'm trying to provide a user with access to a Discover I created and they keep getting this message. What do I need to do to give him access?
- Answered
-
Using Formulas in a Discovery Matrix Grid
Hi everyone, I'm trying to create 3 sub rows (Beginning, Newly Added, and Ending) for each row (subline) in my table. Beginning of one year is the Ending of the previous year.…
- Answered
-
Default to todays date on Date Filter
How do I get the Date Filter to default to todays date on a Discovery? ( Scenario : The user wants to look at a WTD?MTD etc up to a point in time but wants the Date Filter to defaults to today's…
- Answered
-
Fail to get Active Directory users groups
Issue: In the Admin, when assigning Pyramid roles to AD Groups, the role fails to propagate to the user, when the AD group contains special characters, such as "/".…
-
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
-
Ordering the Months
Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…
- 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
Welcome to the Pyramid User Community
Pyramid User Community