-
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
-
Filter on non-existent values (Custom filter)
Hi together, I which to create a filter in publication which also preserves filtering on values which are currently not in the data, so that I get a blank output.…
- Answered
-
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
-
Showing a comparator "geography type" in a chart
Hi all this is tediously basic i assume, sorry. A line chart shows all items that are in "Geography_Type A" where the user can choose the Type: And what i need to do is have a second…
- Answered
-
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
-
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
-
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
-
Dynamic Date Parameters
Are you able to make the maximum year in a date parameter dynamic? So that right now it would give options up to 2020 – but next year, it would automatically update to 2021 without requiring us to…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.