-
Publication with Portrait and Landscape Pages
Hello, I am creating a publication in Pyramid, and have some discoveries which would be better displayed on a portrait page and others on a landscape page - is it possible to change the orientation…
- Answered
-
Best method for displaying four measures on the same visual
We have previously upgraded our Pyramid version from 5 to 2020.10. We used to use funnels to show four related measures on multiple reports, however, as we have seen in the help documentation,…
- Answered
-
Can you change filter conditions in discoveries be OR rather than AND?
We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero. So the condition would look like this: Measure A !…
- Answered
-
How to get the Content Path from the Pyramid Repository in Usage Reporting
In the usage report that I built based on Transaction logs in Pyramid, I am not able to get the 'Path' for my dashboard or report objects. Is there a way to get a path field for the content?
- Answered
-
Custom tooltips, how?
Hi all I'm reading this: https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Present/Present%20Pro/functions/CustomTooltips.htm?Highlight=tooltips Because I need to have control over the…
- Answered
-
Trellis - why the 4 column limit?
Hi I love the trellis charts but is there a practical reason for the 4 column limit? 5 would be excellent, after that maybe some diminishing returns, but for flexibility of design options why not go…
- Answered
-
Partial Replacement of Data
Hi All - Is there any way you can delete a filtered set of records from the InMemory db? I need to replace only the last weeks data with every run since these records are altered in the source data.…
- Answered
-
Include Latest Analysis Services Client Libraries in the WCS role
Hi, We have recently deployed a new multi server Pyramid 2020 solution. As a part of this, we installed the windows connector service on its own Windows Server 2019 Server.…
- Answered
-
how to create nest folder view in configuration section
Hi, May i ask your help how to achieve nested folder structure in Pyramid model development from the snapshot provided the second screenshot is taken as reference from different BI application.…
- Answered
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
Rotate table header text?
Hi all I have a nice simple Matrix grid table, the header texts are all quite long, we cant avoid that, and they're required. I've been trying to see how to rotate the text in this manner (these are…
- Answered
-
Partial Model Update in IMDB
Suppose I have a single IMDB model, which feeds of different sources. These sources may not be available in the same time, or may not update in the same time.…
- Answered
-
How to color lines based on dynamic lists?
I would like to color these lines not based on the years, but on the past 1-12 and 12-24 months. That way it's easy to visually compare two periods during the year and in december it all comes…
- Answered
-
Adding Countries to recognised countries
Hi Is it possible to add followig as countries? 1) Hong Kong 2) Macau Than you
- Answered
-
How would I stop the percent from being displayed in Discover on a Pie Chart?
How would I stop the percent from being displayed in Discover on a Pie Chart? It would be confusing to my end-users.
- Answered
-
Adjust difference between slicers in Discover & Present
We are missing "Combined Elements" as a type in the "Present" slicer At this moment we are using the slicer we made in "Discover" and drag the slicer to "Present", but this is a trick,…
- Answered
-
Embed other reports into Pyramid
Hi guys, I have a question. Is there any way to embed Tibco reports into either Dashboard or Publisher in Pyramid 2020? Thanks, Michael Wu
- Answered
-
Replace a null attribute by another not null
Is there a way to replace one null attribute with another (see attached)? I think it should be done in the cube, maybe... Thank you. Laurent
- Answered
-
Page Repeater add a header/title/group for single pages
Hi together, I have a grid with data like: Manufacturer Model VW Up! VW Polo VW Golf Audi A1 Audi A2 Audi A3 Hyundai i10 Hyundai i20 Hyundai i30 Now I want to put this in a publication to generate a…
- Answered
-
Line Graph: Continuous X-Axis
I have values on my x axis: 0,5,20,50,100,250,500,750,1000,1500 and they are represented as discrete points, equally spaced. Is there a way to make them continuous?…
- Answered
-
Hiding an item from the legend?
Hi I have a couple of items in a Discovery which are there to support the chart structure but shouldn't be in the legend, can i prevent them from showing?…
- Answered
-
Create a horizontal percent calculation
Hi all, is ther any possibility in Pyramid to calculate how many percent 21 - others form the sub total is? I would like to create a new culomn in wich Pyrmaid should wirte the percent for every…
- Answered
-
Distance between KPI Components
Hi, I thought this was changed already, but now I see it in 2020.11.030. Attached is a KPI calculation (3 different measures) in the discover (KPIDiscover), the distance between them is minimal.…
- Answered
-
Is there a way to change date formats in a model?
We are located in the US and would like to change the date formats to a format that our users are used to, such as mm/dd/yyyy. I don't see a way in the model to set the date format displayed.…
- Answered
-
Switch dimensions in a bar/column chart
Hello, Is there any way we could switch between two dimensions in the categories of a bar/column chart? For example, right now we have a visualization prepared to show Financials by Accounting Year,…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.