-
Question on row sorting
I'm converting a BI Office chart. It's laid out like this: Slices - a date parameter at the month level Columns - Two date calculated members that I have defined in my cube (Current Period and Prior…
- Answered
-
Date Parameter for multiple Date ranges
I have to create a date filter that factors in 3 different date ranges. Total date Cost Date Spent Date Each sum needs to be filtered by it's own date but want to create a parameter for one date…
- Answered
-
List Variable in a Model
Hi, i created an model with a single value variable, it works perfectly. But when i change my variable into a list, my query finds no row. I think i don't use the good syntax.…
- Answered
-
Nested Switch Operators in a Set?
Are nested Switch operators supported in a set? It seems as if the set designer allows you to drag a second Switch operator onto the path of one of the options generated from a first Switch operator,…
- 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
-
Save Zoom Level on Map
Hello, I have designed a Map showing KPIs as color indicators on a very local level: Retail Stores in a specific area of one city. It is working quite well,…
- Answered
-
CurrentPeriod & StrToDate in an InMemory Model
Hi, I created an InMemory model in which i have Date elements. When i try to use CurrentPeriod or StrToDate functions, syntax control is ok but result is empty,…
- Answered
-
IMDB Engine and Database Questions
We have several questions regarding the IMDB engine and databases that are created/stored there. Is the memory required for a given database the same as the amount of disk space that the database…
- Answered
-
Multiple Members Search
Is it possible to do a multiple Members Search in Pyramid 2018 as it was in BI Office? As you can see in the first example, I'm searching using barcodes to find the members but when I try the same…
- Answered
-
Stacked Visualizations
Hello there, I have some questions regarding the stacked visualizations in combination with measures. I tried to create a stacked column chart with 3 different measures (3 types of costs).…
- Answered
-
URL Too Long when using an action to drive to another report.
Hello I've created a report which I want to use as a detail report. I create an action so that summary reports can drill down into the detail report using "cell".…
- Answered
-
Usage statistics
Hi team I would to ask if in PA 2018 you have embedded a user usage cube as in BI Office. If not is it in planning? Thx Nikos
- Answered
-
Horizontal bar chart with two values
Hello, Is it possible to create a horizontal bar chart with multiple values in PA2018 similar to one attached here. It seems to come easily with a vertical bar chart but for a horizontal one it just…
- Answered
-
Generate Publication Without Title
I want to generate a publication in excel without title(Indicated with red border in image attached). However, I cannot find a way to do so. Can anybody here help or know a workaround to this…
- Answered
-
Cube measure format options
Hello, I see under a measure there is "Properties" with several options to change the cube format of a measure such as #,#.00 | #,#.0 | 0% ... In Bioffice, there was an option to write your own.…
- Answered
-
Creating a waterfall using deduction amounts
Hi I'm not sure if this is possible but I'm hoping to create a type of waterfall chart where you have the Gross Amount as the start point and then a series of deduction types (COM,…
- Answered
-
Sqoop import to HCatalog/Hive - table not visible
HDP-2.4.2.0-258 installed using Ambari 2.2.2.0 I have to import several SQL Server schema which should be accessible via Hive, Pig, MR and any third party(in future). I decided to import in HCatalog.…
- 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
-
Sort multi-select Slicer
Can we sort data of multiselect slicer(Filter)? I have 'Date' slicer. I want to show Date in descending order.
- Answered
-
Is there any way to get notified when a scheduled Model Data Flow fails?
We are using a model which gets processed everyday. Is there any way in Pyramid to get notification if model processing failed for some reason? Current version of Pyramid we are using is Pyramid…
- Answered
-
Creating Master Slide/Publication Templates
I recently found this documentation online (https://help.pyramidanalytics.com/Content/Root/AdminClient/themes/Master%20Pages.htm?Highlight=present%20template) about creating master templates.…
- Answered
-
Can you rename "Default Section" in a presentation?
We are rebuilding our PowerBI content in Pyramid 2018 and I cannot find a way to rename the Default Section in a presentation. Am I missing something? Thanks!
- Answered
-
Want a appropriate solution for error code RGE-1001.
From the last few days, I have randomly, unable to watch any of the online streaming videos, Actually, I used to watch videos through spectrum app error code rge-1001 is suggested to solve through a…
- Answered
-
Grand Total: calculation
Hi together, I have built a simple table via Discover and created a quick calc: percentage growth between 2018 and 2015. If I now activate "Row Totals" via the Discover Ribbon,…
- Answered
-
Creating/displaying global slicers in present
We have started converting content from BI Office to Pyramid and I haven't been able to find clear instructions on how/if global slicers work in presentations.…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community