-
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
-
Creating a Moving Annual Average
Hi, I am trying to create a moving annual average of customers to feature on a graph I have i created in discover (please see attached). How would I go about doing this?…
- Answered
-
How to combine elements under single header
Hi all, I am looking to combine a group of elements (R1, R2, R3) to create element R which I can use in a Discover Matrix Grid. If I add R1, R2, and R3 to a list then my list of elements looks like…
- Answered
-
Error connecting to MongoDB
I'm trying to join to MongoDB, unfortunately unsuccessfully. ERROR text: "Failed to open connection 'Unable to load authentication plugin 'org.mongodb.mongosql.auth.plugin.…
- Answered
-
'Lagging' Time-Scale in Discovery
Hi all, Please see attached screenshot. I am trying to build a section of an existing report at my company in discovery for export to excel (for the time being).…
- Answered
-
Problems with Custom Maps
I've been creating some map reports and I have a postcode hierarchy consisting of Country, Area, District and Sector. When in the hierarchy, the shapes don't change as you drill down.…
- Answered
-
Column Convert - from String to DateTime
Hello, I am using in a MODEL the column convert function. I try and convert a String into a DateTime format, but the feature does not seem to act consistently.…
- Answered
-
Removing blank member from set [SSAS Tabular 2017]
Hi, When using the Time Intelligence wizard, the Last 3 years also includes an empty member. This is a cube/MDX thing rather than Pyramid 2018 specifically,…
- Answered
-
Exporting as Data Items
Hi, Is it possible to export information produced (in any of discover, publish, present) where the underlying data is visible? Expanding on this, when, for example,…
- Answered
-
Multiple Unions in the same model
I have a model that unions 2 different groups of data. If I remove the second union, the model runs fine, if I add another everything but the target in memory fails with no error but the status…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.