-
Geospatial map using german zip codes
Hi folks, I try to use the geospatial map visual on an AS cube and have understood that I need to somehow combine cities with their countries, because there might be cities with the same name in…
- Answered
-
Migration of repository possible?
Dear all, is there a way to migrate a repository from the standard PostgreSQL to an MS SQL database? Or can I at least transfer the complete content from one Pyramid installation to another,…
- Answered
-
Formulate: Comine Standard List with a Measure
Hi guys, I'm not sure if I'm just "standing on the tube" or if my idea can't be realized, so I hope for your support: In formulate, I want to combine the function of a "standard list" with a measure:…
- Answered
-
Pyramid 2020.03 (Service Pack 3) Released
Service Pack 3 for Pyramid 2020 - 2020.03 - has been released and includes several new features and fixes. Software The installer files can be downloaded from the Pyramid Customer Portal.…
-
When trying to use an R script from the Market Place an error occurs
When trying to use a script from the Market Place that uses one of R packages e.g the “Sentiment analysis” (uses stringr package) the following error occurs: "scripting error:Error:…
-
Rank
Hi I'm looking to create a rank column as a measure so that I can then say x broker (in slicer) is ranked y out z as dynamic text. I did attempt to use find row number by caption however the caption…
- Answered
-
IMDB - Questions about modelling
Hi everybody, could anyone of you please help me to get things into order? I have two users A and B belonging to the same role and profile and having the same access to the available datasources.…
- Answered
-
Security option: Read vs. Manage
Hi together, I have a short question and wasn´t able to find this topic via the Pyramid help: Within the content permission settings (Actions Panel -> Roles):…
- Answered
-
Cascading Slicer question
I have a report that had non-cascading slicers for Course College and Course Department. The report displays Course Section and Attempted Class Count. It made sense to have a cascading slicer for…
- Answered
-
Google Analytics
Hi folks, am I right assuming that Google Analytics can be used as a datasource for the model module, but cannot be queried directly from a discovery? Regards Markus
- Answered
-
The seven success factors of time intelligence
Date-time analysis is a central pillar of modern analytics. Every business needs to track progress over periods of time, and more importantly, compare and evaluate that progress between two time…
-
Change LDAP 389 to LDAP 636
Hi all, as soon as i change the port from 389 to 636 and the LDAP address to LDAPS in the domain settings, the connection no longer works. Does the port 636 in Pyramid not work?
- Answered
-
Access: designate User Defaults
Hi there, As Administrator, I recently stumbled acrossthe "User Default" section via the Access Tab. This function seems to be new and may be used to configure default settings for each user?…
- Answered
-
Defining Custom Color Palette
Hi there, today I used the "more color" option to define a custom color to work within my publication. After generating these Custom Colors, they were availabe in all modules and options where its…
- Answered
-
Question on row sorting
I'm converting a BI Office chart. It's laid out like this: Slices - a date parameter at the month level Columns - Two date calculated members that I have defined in my cube (Current Period and Prior…
- Answered
-
Date Parameter for multiple Date ranges
I have to create a date filter that factors in 3 different date ranges. Total date Cost Date Spent Date Each sum needs to be filtered by it's own date but want to create a parameter for one date…
- Answered
-
List Variable in a Model
Hi, i created an model with a single value variable, it works perfectly. But when i change my variable into a list, my query finds no row. I think i don't use the good syntax.…
- Answered
-
Nested Switch Operators in a Set?
Are nested Switch operators supported in a set? It seems as if the set designer allows you to drag a second Switch operator onto the path of one of the options generated from a first Switch operator,…
- Answered
-
Grand Totals Not Working with Filters
Hi! I don't know if I'm doing something wrong but the Grand Totals are off when you put a filter. It does not recognizes the filtered list, the total is still on the entire data selection.…
- Answered
-
Save Zoom Level on Map
Hello, I have designed a Map showing KPIs as color indicators on a very local level: Retail Stores in a specific area of one city. It is working quite well,…
- Answered
-
CurrentPeriod & StrToDate in an InMemory Model
Hi, I created an InMemory model in which i have Date elements. When i try to use CurrentPeriod or StrToDate functions, syntax control is ok but result is empty,…
- Answered
-
IMDB Engine and Database Questions
We have several questions regarding the IMDB engine and databases that are created/stored there. Is the memory required for a given database the same as the amount of disk space that the database…
- Answered
-
Multiple Members Search
Is it possible to do a multiple Members Search in Pyramid 2018 as it was in BI Office? As you can see in the first example, I'm searching using barcodes to find the members but when I try the same…
- Answered
-
Stacked Visualizations
Hello there, I have some questions regarding the stacked visualizations in combination with measures. I tried to create a stacked column chart with 3 different measures (3 types of costs).…
- Answered
-
URL Too Long when using an action to drive to another report.
Hello I've created a report which I want to use as a detail report. I create an action so that summary reports can drill down into the detail report using "cell".…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community