-
Multiselect Dynamic measure
Hello! Is it possible to use multiselect with Dynamic measures? The way I tried in the picture is not working. Kind regards, Dennis.
- Answered
-
Indicators with multiselect measures
Hello! Does somebody know how to use the indicators in combination with the multiselect measures? See attachment. The indicator will be removed when I change to another dynamic measure.…
- Answered
-
Calculating max/min difference in context
Hi there i want to reduce a range of time series lines into a single area spanning the max and min values in each time point. I've had a go with creating an Fx but i suspect i need a context…
- Answered
-
Pyramid 2020.11 (2020.10 + SP1) Released
Pyramid 2020.10 service pack 1 - version 2020.11 - has been released and includes a collection of fixes and improvements. Software The installer files can be downloaded from the Pyramid Customer…
-
Passing Parameters to Stored Procedures
If we have a Stored Procedure in the database server to which I need to pass a decryption key (string/text) in order to decrypt the numeric sensitive data,…
- Answered
-
SSAS Currency Symbols
Does Pyramid support dynamic Currency Symbols that are configured in the SSAS cube using "Language( )" MDX? I'm not seeing that the symbols are being allowed through to Pyramid. Is this supported?
- Answered
-
How to apply Cumulative Function (Percent of Total) of rows/columns in Charts.
The "Percent of Total" calculation is a context calculation that is designed to factor the "shape" of the query in determining the scope of the calculation.…
-
Retrieving XMLA to analyze cube structure
Below are instructions on how to get the cube structure (dimensions, hierarchies, measures…) It can help the Pyramid development team debug cases where the query fails to get the cube metadata.…
-
Creating an IMDB Time column in the Model designer
In the current version of Pyramid (2020.10), the Time type column is not supported when creating an IMDB model. As a result, it will appear in a Discovery report but it will not be possible to…
-
YTD Functions
For the YTD to work properly, do you need to have a date field in your model? Or can it also work on 'text fields' set as your periods?
- Answered
-
Client help search problem?
Hi there i'm not getting any answers when searching the Client Help, even if i search for a phrase i can see in a help page, when using Chrome. Seems fine in Edge though.…
- Answered
-
Uncaught SyntaxError when using Embedding
ISSUE: When trying to embed Pyramid content the following type of error is shown: Uncaught SyntaxError: Invalid regular expression:…
-
Real self-service BI for SAP BW and HANA for Pyramid Customers
Pyramid is certified by SAP to interoperate with SAP BW/4HANA. Pyramid is pending certification by SAP to interoperate with SAP HANA. Pyramid also became an official member of the SAP® PartnerEdge®…
-
Related content -> metadate available as source in model?
Hi, I'm new to Pyramid. I've searched the forum but haven't found an answer to the following question: For operational purposes (Something is broken, where is the impact?…
- Answered
-
Line chart - multiple items, all one colour
Hi I've a bar chart which was multicoloured when new, i dragged the Geography item from Colour zone to Categories zone and the chart bars all became default blue which is just excellent.…
- Answered
-
How to create a Week to Date or Parallel Periods list, for a week that starts on Sunday when using a sql data source
Week to Date, using a specific date: 1. Create a new List in Formulate 2. Drag ‘Week to Date’ into the canvas, choose a date under Pick a Member: 3. Set the Day of the week to start from 7,…
-
Creating a Date Time intervals in Data modeling tool
When creating a SQL based model, you can create a time interval column using a custom "Date time" type column (i.e 12:00,12:15,12:30,12:45, 13:00). To do this,…
-
Show Empties - In Memory
Hello, I have built a new in-memory Pyramid model, and I have a table with a list of Pack Benches (numbered 1-10). When I don't include a measure, it shows all elements of the dimension (see…
- Answered
-
change start of week in Data Flow (Advanced Time Intelligence)
Hi everyone, I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by @Avi Perez in the Product Ideas forum.…
- Answered
-
Salesforce as Data Source with filtering
Hello, I do not see there is a way to use SOQL Query from Salesforce as Datasource like a SQL Query from the SQL/Access database. Does anyone have examples of adding filters to the Select before…
- Answered
-
Pyramid 2020.10 Released
Enhance Trusted Analytics Capabilities Version 2020.10 is a follow-up release of Pyramid this year to 2020.0. It includes over 150 new features and functional upgrades together with numerous fixes -…
-
Folder & Location URLs
Hi, I am wishing to be able to send out a link to a folder\reports relative location and not the unique id currently assigned to the reporting item. Is it possible to use a URL to navigate to a…
- Answered
-
Pyramid 2020.10 Issues Addressed
Back to Pyramid 2020.10 release announcement The following list enumerates all the main bug fixes and small features added to the 2020.10 version. Application Fixes and Features Model Fixed an issue…
-
Security Notice: Linux Installations 2020.00-2020.05
Issue Level: MEDIUM-HIGH Overview The password for the internal system account used with Pyramid installations on Linux servers is not being set correctly to a random value during installation.…
Welcome to the Pyramid User Community
Pyramid User Community