-
Data Not Current
I have a view in a SQL Database and used the Data Model to pull data to a Pyramid Data Discovery view. The data in the SQL View pulls real time data, but the data in Pyramid only shows as of the…
- Answered
-
Data Model- two relationships for two tables
Hi! In data Model, tables-> Is it possible to make for two tables two different relationships for different columns? I want to make for the same two tables once a inner join relationship and for…
- Answered
-
Is Embed license included in Standard or Enterprise license?
According to the help page of Embedding, a separate "Embed" license is needed to use this feature. I couldn't find any information about this license in the pricing page.…
- Answered
-
Possible to Add R and Python Packages?
Is it possible to install additional R and Python packages to a Pyramid 2018 installation to provide access to additional functionality for those who want to leverage the Formulate tool to create…
- Answered
-
Join Options in Model
In version 2018-03, I can't no more using Left Join, Right Join or Outer Join, just Inner Join is available. Is it a definitive choice ?
- Answered
-
Dimension changer Slicer
Hello, I was just wondering if it was possible to have a slicer that dictates which dimension the report is split by - for instance the measure could be goals and then you would have slicer that…
- Answered
-
Send a publication in attachment
when i perform a Scheduled plublication by mail, i recieve correctly the mail notification. Is-it possible to send publication in attachment ? Thanks
- Answered
-
What is initial user when changing provider from DB to AD?
What should be the initial user when we change provider from DB to AD? I tried the name of the Enterprise Users created on Pyramid, but it doesn't work.
- Answered
-
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
Got stuck with a report? Start a discussion or help others to move forward.