-
Folder & sub-folder in Measure group
Hi I would like to create a subfolder in a measure group - is that possible? If I do that, all other folders disappear and all KPIs are shown without folder (see image). thanks!
- Answered
-
Unit of Measure
Hi! I would like to add a unit to each measure (e.g. "EUR" or "pcs") which can be shown or hidden, depending on the preference - is that possible? Thanks!
- Answered
-
Question about Sets and Display Folder in SSAS Cube
Hey guys, we would like to use sets and display folders in a SSAS cube. Unfortunately both doesn't really work correctly. First issue we're having is related to the set "LastWeek" which is shown in…
- Answered
-
Folder & Location URLs
Hi, I am wishing to be able to send out a link to a folder\reports relative location and not the unique id currently assigned to the reporting item. Is it possible to use a URL to navigate to a…
- Answered
-
How to add two members together?
Let's say that we have a report that contains a list of countries. Is there a way to combine two or more countries into a new aggregate value. For example, Canada + USA = North America?
- Answered
-
How to remove the descriptive text above a Discover Report
When you work with a grid in Discover, there is a text thread above it that contains all of the selected values in the query. Is there a way to remove this from the view?
- Answered
-
Announcement: Pyramid Office Hours
Last week, we officially kicked off our Pyramid Office Hours series. In these free sessions, we want to provide new and experienced Pyramid users alike the skills they need to be successful.…
- Answered
-
Number formats - "#,##0;(#,##0);" Only works for some users.
Hi, I am have an issue with the need to format a report consistently. The issue is that within the discovery pivot we have added which we need format "#,##0;(#,##0);".…
- Answered
-
Range List Using Two Date Hierarchies
Hello, I don't think this is possible but thought it's worth a shot asking the question! I have a discovery with filters for TransDate and ClosedDate. The aim is to see open transactions at the end…
- Answered
-
Drill Through within Measure?
I was wondering if there is a function in pyramid which allows me to drill down/through to a single line item (if it is not linked to a hierarchy)? I can always right click e.g.…
- Answered
-
Blank Pages
We have a multipage publication that we print multiple times for different facilities. Not all are facilities have data on every page, so the page is blank.…
- Answered
-
Gauge Tri band
Hi, We've just started using the latest version. But the KPI triband for gauges inst behaving the same. As you can see from the pics i set the bands but the dial doesn't display them Thanks
- Answered
-
Can I Publish to pdf and have Discoveries wrap onto subsequent pages?
Am I missing a setting to allow an exhibit to overflow from one page onto another? The discovery object I want to embed would run to two or three pages in pdf,…
- Answered
-
Market Basket
I am trying to do a market basket analysis in R but I get this error : Etl failed while executing - %sno params. Please assist.
- Answered
-
Is there any way to count filtered rows in formulate?
Hi together, Is there any way to count filtered rows in formulate? SID Status 1 True 2 False 3 True 4 True I need to count all rows and then just rows which are true,…
- Answered
-
Add interactions accross diffent slides
Hello together, Is it possible to add interactions across different slides? Like one master page where the user can select all necessary filters and then all following pages will react on this.…
- Answered
-
Single/MultiSelect Tree Slicer Default Selection
Is there a way to select a default position for a single/multiselect tree slicer? Example: We are trying to have our slicer be an account open date, so it is set to a regular hierarchy,…
- Answered
-
Load a whole folder and append multiple same-structure CSV file
Greetings! I looking for a way to load and append a whole set of files into Pyramid (same-structure files from different divisions, or from different days).…
- Answered
-
Last updated date & time
I remember in BI Office, it was possible to add a text field showing the date and time the source model was last updated. I cannot seem to find this in Pyramid (2018.05.…
- Answered
-
Find Difference between two dates
Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?
- Answered
-
Migration of repository possible?
Dear all, is there a way to migrate a repository from the standard PostgreSQL to an MS SQL database? Or can I at least transfer the complete content from one Pyramid installation to another,…
- Answered
-
Twitter Source questions
We recently received a few questions regarding the Twitter data source. We thought to share the answers with you. What search options do we have with the Twitter source node in Model?…
- Answered
-
Formulate: Comine Standard List with a Measure
Hi guys, I'm not sure if I'm just "standing on the tube" or if my idea can't be realized, so I hope for your support: In formulate, I want to combine the function of a "standard list" with a measure:…
- Answered
-
How can we identify which part of a theme to change?
Wondering if there is some kind of documentation that would help me identify which part of a theme to update to have the impact I'm wanting in a Discovery.…
- Answered
-
Geospatial map using german zip codes
Hi folks, I try to use the geospatial map visual on an AS cube and have understood that I need to somehow combine cities with their countries, because there might be cities with the same name in…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.