-
Is there any way to count filtered rows in formulate?
Hi together, Is there any way to count filtered rows in formulate? SID Status 1 True 2 False 3 True 4 True I need to count all rows and then just rows which are true,…
- Answered
-
Add interactions accross diffent slides
Hello together, Is it possible to add interactions across different slides? Like one master page where the user can select all necessary filters and then all following pages will react on this.…
- Answered
-
Single/MultiSelect Tree Slicer Default Selection
Is there a way to select a default position for a single/multiselect tree slicer? Example: We are trying to have our slicer be an account open date, so it is set to a regular hierarchy,…
- Answered
-
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
Welcome to the Pyramid User Community
Pyramid User Community