-
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
-
Data model Hierarchy - Tree slicer
Hi everyone, I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure. The problem I have is that it works well with double click and drill down,…
- Answered
-
Top N - List
Hi We have a list of days which are numeric but not a measure. the values range from 0 to 900. We want to only show the element where they are greater than a specific value set by a continuous…
- Answered
-
Concatenate dimension values
Hello, Is there a way to concatenate two dimension values, like customer number and customer name, in a formula? As an example we have customer number "123" and customer name "ABC Appliances" and we…
- Answered
-
Pyramid 2020.05 (Service Pack 5) Released
Service Pack 5 for Pyramid 2020 - 2020.05 - has been released and includes a collection of fixes and improvements. Software The installer files can be downloaded from the Pyramid Customer Portal.…
-
custom login page
Hello, How do I send the login credentials from a custom HTML login page with the link to the specific dashboard URL? Thanks
- Answered
-
Get notified if Pyramid Services go down
We have had sporadic instances where some of the Pyramid Services crash. It gets reported in the logs. Is there a way to have Pyramid notify our admins when this happens so they can restart the…
- Answered
-
What is required for my company to use Pyramid on mobile devices?
I want to use Pyramid on my mobile device. How do I get access to it? Is the functionality included or does it cost extra?
- Answered
-
Do Desktop and Mobile dashboards use the same URL link?
When I convert the desktop dashboard to a mobile dashboard then do we keep the same link for both the dashboards or there are two different links to access the dashboard?
- Answered
-
Changing Slicer Settings
I've noticed that when I change a slicer from Single Select Tree to Multi Select Drop Down that it places my Single Select Tree selection into the background and does not change the Slicer Type.…
- Answered
-
Cannot access Pyramid using IIS
After Pyramid 2018 installation, when using the IIS option, if you cannot access the Pyramid 2018 from a browser using the IIS bindings you chose, please check, in the control panel,…
-
Unique Customers count that bought multiple items at a site
Okay, banging my head and it hurts. While the actual data is patient centric around different codes styles of Veterans Administration will ask it in sales terms.…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community