-
YTD Functions
For the YTD to work properly, do you need to have a date field in your model? Or can it also work on 'text fields' set as your periods?
- Answered
-
Client help search problem?
Hi there i'm not getting any answers when searching the Client Help, even if i search for a phrase i can see in a help page, when using Chrome. Seems fine in Edge though.…
- Answered
-
Uncaught SyntaxError when using Embedding
ISSUE: When trying to embed Pyramid content the following type of error is shown: Uncaught SyntaxError: Invalid regular expression:…
-
Real self-service BI for SAP BW and HANA for Pyramid Customers
Pyramid is certified by SAP to interoperate with SAP BW/4HANA. Pyramid is pending certification by SAP to interoperate with SAP HANA. Pyramid also became an official member of the SAP® PartnerEdge®…
-
Related content -> metadate available as source in model?
Hi, I'm new to Pyramid. I've searched the forum but haven't found an answer to the following question: For operational purposes (Something is broken, where is the impact?…
- Answered
-
Line chart - multiple items, all one colour
Hi I've a bar chart which was multicoloured when new, i dragged the Geography item from Colour zone to Categories zone and the chart bars all became default blue which is just excellent.…
- Answered
-
How to create a Week to Date or Parallel Periods list, for a week that starts on Sunday when using a sql data source
Week to Date, using a specific date: 1. Create a new List in Formulate 2. Drag ‘Week to Date’ into the canvas, choose a date under Pick a Member: 3. Set the Day of the week to start from 7,…
-
Creating a Date Time intervals in Data modeling tool
When creating a SQL based model, you can create a time interval column using a custom "Date time" type column (i.e 12:00,12:15,12:30,12:45, 13:00). To do this,…
-
Show Empties - In Memory
Hello, I have built a new in-memory Pyramid model, and I have a table with a list of Pack Benches (numbered 1-10). When I don't include a measure, it shows all elements of the dimension (see…
- Answered
-
change start of week in Data Flow (Advanced Time Intelligence)
Hi everyone, I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by @Avi Perez in the Product Ideas forum.…
- Answered
-
Salesforce as Data Source with filtering
Hello, I do not see there is a way to use SOQL Query from Salesforce as Datasource like a SQL Query from the SQL/Access database. Does anyone have examples of adding filters to the Select before…
- Answered
-
Pyramid 2020.10 Released
Enhance Trusted Analytics Capabilities Version 2020.10 is a follow-up release of Pyramid this year to 2020.0. It includes over 150 new features and functional upgrades together with numerous fixes -…
-
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
-
Pyramid 2020.10 Issues Addressed
Back to Pyramid 2020.10 release announcement The following list enumerates all the main bug fixes and small features added to the 2020.10 version. Application Fixes and Features Model Fixed an issue…
-
Security Notice: Linux Installations 2020.00-2020.05
Issue Level: MEDIUM-HIGH Overview The password for the internal system account used with Pyramid installations on Linux servers is not being set correctly to a random value during installation.…
-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
SSAS: Formulate across cubes and/or databases
Hi folks, is it possible to calculate values across different cubes located in the same or even in different SSAS-databases? I tried with just putting the cubes' name in front of the MDX and was…
- Answered
-
Click or drag to add measure - any difference?
Hi all, when i tick a measure Pyramid will add it to in this case a table - adding it to both the Values card, and the Columns card, the column it creates is also named with the Measure name.…
- Answered
-
External Actions / Workflow
HI, Does Pyramid have the ability to support a 'sign off' workflow -- ex: user reviews a dashboard and clicks to indicate that the visuals have been reviewed. We'd like to capture the signoff.…
- Answered
-
Motion ranking
Hello all, very new to Pyramid (day2) and I've got a bar chart with date driving motion and am trying to sort the display order of the bars to always be descending (so they may have to swap places…
- Answered
-
Best practice for embedding Pyramid presentation into Salesforce
We want to embed graphs and presentations into Salesforce. What is the recommended approach for doing this?
- 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
-
Creating a calculation to provide difference between two columns of numbers
We have reports that use named sets to provide four years of data and need to show the difference between the last two. We've done it with a quick calc using data points but we find that these hard…
- Answered
-
Notification for failure of scheduled model refresh?
Is there any way to send a notification when a schedule model refresh fails?
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help