-
Can I create a custom hierarchy of measures
I saw this article, https://community.pyramidanalytics.com/t/h7h92p1/how-to-combine-values-from-different-measures-in-one-charts. Is it possible to create a custom hierarchy of measures?…
- Answered
-
get measure monthly count for last 12 months
I have a [Measure] and that I want to show it's trend on a monthly basis. Therefor I created the following logic: strtomember("[Date].[Calendar].[Date].["+ format(now()-1,"yyyy-MM-dd")+"]").parent.…
- Answered
-
How to save the Analysis measures.
Hi, I have calculated some measures by using Analysis like Forecast, Regression, Statistics so on. I couldn't able to share(right click -Mark shareable option) the measures.…
- Answered
-
"Classic Pivot table" design
Hi, I want to create a table that is similar in style to the classic pivot table in excel. In that sense I also wish to add multiple attributes from the same "dimension" from my data source/cube.…
- Answered
-
Optimizing a Star Schema Data Model
Is there any best practice documentation or tools available for optimizing star schema data models in Pyramid?
- Answered
-
Sankey Chart - Source and Target Same Dimension
Hi I am looking to create a Sankey chart where the source is a month (I want to select a start month using a parameter) and the target is the same month dimension however I want to select an end…
- Answered
-
PQL Date Query
I currently have a list that is relying on a parameter in a date format of "Mmm YYYY". This controls two separate formulations that utilise the YTD & lag functions so I can get a YTD and then a prev…
- Answered
-
differences in standard deviation
Hi, I am working on a scatter plot and want to show the standard deviation. I have used three different methods, one from formulate which gives one standard deviation line (green line),…
- Answered
-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- Answered
-
custom login page
Hello, How do I send the login credentials from a custom HTML login page with the link to the specific dashboard URL? Thanks
- Answered
-
Number formats - "#,##0;(#,##0);" Only works for some users.
Hi, I am have an issue with the need to format a report consistently. The issue is that within the discovery pivot we have added which we need format "#,##0;(#,##0);".…
- Answered
-
Drill Through within Measure?
I was wondering if there is a function in pyramid which allows me to drill down/through to a single line item (if it is not linked to a hierarchy)? I can always right click e.g.…
- Answered
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- Answered
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
Calculate difference between columns
I'm trying to create a very basic grid that has two Terms in the columns and several measures in the rows. How can I add another column that shows the difference between the measures for the terms?…
- Answered
-
Formating line chart series
When I try to set dashed line and data labels for only one series in line chart with roght click on item in the legend. That work for only one series and formating is not aplied to selected series,…
- 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
-
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
-
Transparency doesnt work ? (PA 2018 04.460)
Dear Colleagues, first of all, i just registered to the PA Community so please help me to orient myself if this isn´t the right place for this kind of question!…
- Answered
-
Background member
Hello, In the latest Q&A webinar I noticed that in the demo discovery there was a background element visible. What's the use case for this and how does this work? Br, Simo
- Answered
-
MS Tabular connection error
Hi Team, We are getting error while taking the MS Tabular and MS OLAP connection . We tried all the possibilities but we didn't get the connection could you please check it once. Thanks, Praveen.
- Answered
-
KPI with dynamic texts
Hello, I am trying to add a dynamic text to the KPI which shows a Year-over-Year change in between the quarters in my presentation. However, the text only returns a result if all years,…
- Answered
-
How to set environment variable in pyramid
I'm trying to set environment variables in Pyramid & access it in my python script within Pyramid. But I'm facing an error, environment variables not set.…
- Answered
-
Allow microphone use in a browser or mobile app
Hello Community, When using the chatbot, clicking on the microphone icon produces the following error message: Unable to access your microphone. Make sure that your microphone is enabled in the…
- Answered
-
Renaming a measure
I want to rename a measure from the model. I try it from the model in the tables part and then "Display Name". But after changing it I see the original name in the discovery and nothing changes.
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help