-
How do we adjust area chart colouring?
Hi all, ok so i have a stacked Area Chart with two values over time, the final result needs to be showing just the upper area, the lower totally invisible.…
- Answered
-
Example of how to authenticate and embed Pyramid content.
For Embed on Pyramid 2020.11 please see this link. Below is a simple example of a web page that displays Pyramid content and authenticates to the Pyramid Embed API in order to create a cookie for…
-
List Printing
Hello everyone, Is it possible to print in Presentation or Publication, a list that is larger than one page? This list would continue on the next page. Guillaume A.
- Answered
-
Filtered filters ->Selecting "All" should impact only filtered entries
When opening a (multiselect drop down) filter and typing a key (e.g. "m") then the filter does temporarily show only those entries beginning with "m". Additionally, it shows the option "All".…
- Answered
-
Population pyramid part 2 - axis extents
Hi all, thanks again to Ian for your help in my other post https://community.pyramidanalytics.com/t/60hxcbn/making-a-population-pyramid-chart-specify-total-for-and-reverse-axis-direction I've used…
- Answered
-
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
Welcome to the Pyramid User Community
Pyramid User Community