-
Condition Or / And in Model Data flow functions
how can i apply a condition Or / And in calculation column ? this syntax generates an error : if([Test_CP] !=="P" or [Test_CP] !=="F" ,"Chambre double","Chambre particulière") This one too :…
- Answered
-
MAX Function within formula
Hi there, I'm completely new to Pyramid Analytics so this is a fairly basic question. What I'm aiming to achieve is a list of customers and against the list of customers I would like to show the…
- Answered
-
Change connection string
I imported report items from another Pyramid Server. The Report Items are visible, but now I need to change the connection string from the list menu (without opening the item) so that it opens.…
- 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
-
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
-
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
-
Adding columns at different drill down levels
I am trying to create a report that shows additional columns at lower levels of the drill down hierarchy. This is how my hierarchy is set up: YearBooked MonthOfYear PolicyNumber I would like to set…
- Answered
-
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
-
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
-
Sorting Question with Stacked Hierarchies
Is it possible to apply sorting to an inner hierarchy stacked with an outer hierarchy so that the inner hierarchy is sorted while respecting the current member of the outer hierarchy? For example,…
- Answered
-
Filter values in presentation?
Hello, I was wondering if I am doing something wrong as I am not able to add a filter/slicer for values in the presentation mode? It works on the discovery mode but in presentation mode I am able to…
- 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
-
MS Tabular connection error
Hi Team, We are getting error while taking the MS Tabular and MS OLAP connection . We tried all the possibilities but we didn't get the connection could you please check it once. Thanks, Praveen.
- Answered
-
Move an IMDB Model to Another Server?
If we have an IMDB server with several models on it and add a new IMDB server, is there a way to move one or more of the existing models from the first server to the new one?
- Answered
-
Weird legend?
Hi all I was asked to create a chart with 3 measures (Effectivity, Efficiency & Productivity) over time (last 6 completed months) for a a organizational Hierarchy.…
- Answered
-
Using the mobile app
Hey there, I would like to use my mobile phone (Android) to open my Presentation. I need to open a link but when i copy the link and add it to word for example, i always get the localhost in the url.…
- Answered
-
Boxplot Visualization
Hi there. I'm wondering if it is possible to create a boxplot or similar visualization in Pyramid 2018 that illustrates all the data points for a category along their range.…
- Answered
-
Enable export themes from BI Office to Pyramid 2018
Can the Pyramid team provide themes for Pyramid 2018 that match the themes that are available in BI Office? In particular, some of the default themes like Pyramid 2013 and Pyramid 2016 would be very…
- Answered
-
Why Are Themes Not Securable Objects?
Given that themes now appear to include features for defining specific master pages for presentations and publications, it would seem helpful to have themes be securable objects so that only certain…
- Answered
-
Edit/customize a (global) slicer in Presentation
Hello, I added a New Slicer to a Presentation, based on a Product dimension. In BI Office it was possible to filter such a slicer (select only the elements you want to include in the list) and to…
- Answered
-
About chart design
Hello I'm replicating my BI Office reports into P2018. It seems that P2018 has some restrictions in scaling the legends (see below the legend for the same chart in BI Office vs P2018).…
- Answered
-
Column chart: data labels inside/outside & text direction
Hi, I created a column chart in Pyramid 2018. how can I put the data labels outside the column? And can I change the text direction to horizontal? Thanks in advance! Regards, Rutger Lammers.
- Answered
-
Machine learning scripts
The ML library in Pyramid 2018 is a very nice addition. However, is it possible to see the scripts behind the algorithms (as was the case in BI Office)?…
- Answered
-
Bar chart with multiple measures
Dear all just started working with Pyramid 2018 and I have a question. I want to create a bar chart with dimension: 1 hierarchy values: 3 measures , something like this:…
- Answered
-
Flow Grid in Publish
Hi, I couldn't find the flow grid in the publish app, is this something that is coming or am I missing something? Thanks
- Answered
Got stuck with a report? Start a discussion or help others to move forward.