-
Rolling Average IMDB Model
Hi, Is there any way of creating a 3/6/12 month rolling average in an in memory data base model? I have tried creating a range list between current member and a lagged value but this doesn't seem to…
- Answered
-
embedding with php or python
I have seen examples of using the embedding functionality with c#, java, and js/ajax? Does anyone have a example in php or python? Thanks. Kevin
- 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
-
Dynamic Eliminations
I’ve been trying to do some dynamic eliminations using sets of sets. i.e creating two crossjoined sets (from 2 different dimensions) then making a set of the resulting sets.…
- Answered
-
Cumulative total using Lists
I was looking at creating a measure for the Cumulative Quantities sold over time for individual products. I used the contextual "quick" cumulative measure within the discovery and it seemed to work…
- Answered
-
Azure Analysis Services
Does anyone here actively use Azure Analysis services? How do you find it?
- Answered
-
MODEL: Change stored procedure used to access data on SQL Server.
Hello, I have been testing Pyramid. In a model, we can obtain data from a SQL Server from a table or executing a stored procedure. If I want to use another table,…
- Answered
-
List last FULL month
Hi, I am not sure if I am doing something wrong, but I can't work out how to create a set containing dates from the last full month (so today, I want all dates in February).…
- Answered
-
Removing extra whitespace on Storyboard
When I add a report to a storyboard and try to shrink the panel smaller, I get '0.0 Measure' and my report doesn't display. How can I remove the extra whitespace?…
- Answered
-
Moving existing Pyramid 2018 setup to new server
Hi, we'd like to change the server on which Pyramid is installed. What would be the best path to migrate our content to a new machine? Actual setup is using a local Postgre database.…
- Answered
-
Help with displaying full year and Week To Date
Hi, My users have two separate data discovery that they would like combined in to one, and I can't seem to figure it out. They both have a year week hierarchy on columns,…
- 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
-
Discovery chart - how to show % values to 1dp?
Hi all, In my discovery chart, I would like to show my axis labels to 1 decimal place (they currently show to 3 decimal places). E.g. they show 1.200% when there is really no need.…
- Answered
-
getAllConnectionStrings returning a 302
When I try to hit my instance of the Pyramid API 2.o to getAllConnectionStrings I am receiving a 302. How can I remedy this problem?
- Answered
-
How to hide or remove Cumulative Total (Column Measures)
Hello, I have applied Cumulative total on Returns and moved it to Rows so that the cumulative totals are applied on Row level. How to remove or hide this measure column? TIA.
- Answered
-
Parameters don't seem to be working
I added a parameter to one of my dimensions which I also have in rows in my grid. I am not sure if I did something wrong, but when I change the selection in the parameter's drop-down,…
- Answered
-
What happened to sorting?
My experience previously was that I could have Elements show up in a report in the order I selected them. What I am currently experiencing seems to be it puts all "standard" Elements (i.e.…
- Answered
-
Experience going from BI Office to Pyramid 2018
Hi All, We recently upgraded to v6.5.2 but were wondering what your experience has been going from BI Office to Pyramid 2018 including converting existing storyboards and reports.…
- Answered
-
Switching from AD to SAML
We would like to switch our authentication from AD to SAML. I have reviewed the documentation, but I was wondering if anyone has configured SAML and what your experience was.…
- Answered
-
Server Sizing
We are new to Pyramid 2018 and are trying to get an idea on server sizing, in particular memory and cpu, before we lock in our configuration in AWS. Our current config is: Processor:…
- 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
-
Number Formatting in Discovery
Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…
- Answered
-
Publication - Slicers for email and display name
Hi, I have a publication that is distributed by email address, which is a slicer in the publication. I also use this email address in some dynamic text on the front page of the publication.…
- Answered
-
implementattion of chord chart in pyramid 2018
Hi Team, Do we have an option of implementing chord chart in pyramid 2018? If yes,can you please help me out on this? Thanks, Regards Manish
- Answered
-
NQL and OLAP models
We noticed that natural querying and some other cool features (Time Intelligence, Clustering, Outlier analysis,…) don't work with OLAP models, but only within Pyramid-created models.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.