-
Grouping of dimension
Hi guys I have a dataset like this: DimensionValue - Measure 1 100 3 100 6 200 9 100 12 500 etc. I want to group the dimension and aggregate the measure per group (for example) (1,3,12) AS Group 1 :…
- Answered
-
Publish Excel as attachment that looks like Copy Content
I need to know how to get a Published Excel report to look like it was created as if you used the Copy Content button and pasted it into Excel manually.
- Answered
-
Email address in text component
Hello Is there a way to create a mailto in a text component in a presentation? It would be nice to add the support email to a dashboard and with one click to open the mail client
- Answered
-
Global variable in the Pyramid 2018
Hello, Is the global variable functionality available in the Pyramid 2018? If not, what alternative would you suggest to use for the conditional display? Thanks
- Answered
-
Choropleth Maps
Hello, What choropleth maps are available within the Pyramid 2018? I saw a few examples with the US State level choropleth maps. Are there any other available?…
- Answered
-
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
Got stuck with a report? Start a discussion or help others to move forward.