-
Rotate table header text?
Hi all I have a nice simple Matrix grid table, the header texts are all quite long, we cant avoid that, and they're required. I've been trying to see how to rotate the text in this manner (these are…
- Answered
-
Analysis Services Dynamic Management Views as IMDB Data Source
Hi, I have an Excel file with that uses custom .odc files as data sources with a connection string to analysis services and MDX query to pull back DMV's.…
- Answered
-
Display weather on map with data points
Hello, We are trying to identify if there is a way to map customers address on a weather map to identify who would be affected by a storm. Do you have some ideas on how this might be accomplished.…
- Answered
-
Authentication by Azure Active Directory (AAD)
Dear Pyramid, on behalf of my company's system admin I would like to ask the following question: Are there any plans to support native Azure Active Directory Authentication using Microsofts…
- Answered
-
Combine members of different dimensions as a new dimension
Hello I am trying to create a new dimension by combining members from two other dimensions. Is this possible? For example: Combining a member from the Product dimension with a member from the…
- Answered
-
Stacked and non stacked chart together
Hi I have four measures, one being premium, and then an set of data of claims split by type, I want to see the premium as one colour in its own bar, and then the 3 claim types stacked together…
- Answered
-
Can you drill down by column instead of cell?
For example i have a date hierarchy for years , quarters and months. The user want to click on inception date hierarchy and drill down from years to quarters so the entire presentation shows all…
- Answered
-
Background Colour cells based on IF formula
As per the above, I have created an IF formula to specify what colour I want the cell to be, based on the value of the measure. This doesnt seem to work no matter what I try when dragging the…
- Answered
-
Using URL Parameterization
I am currently trying to figure out how to parametrize a URL in order to link directly to a Present whose data would be filtered by the other application.…
- Answered
-
Negative number formats
I have been asked to produce a report with a very particular number format, and I can't see a way to do it They want negative values to be shown in parentheses and in red- I have managed to get the…
- Answered
-
Scaling options in Present panels
The current options for scaling in presentation panels do not allow for scaling on width, so if I have a grid that's wider than the panel, the only option I have to get the columns to fit is "scale…
- Answered
-
How to calculate aggregate correctly without using underlying details
Hello, Background: We use Pyramid 2020.15.046 against a SSAS datasource. I want to calculate the amount of interesting clients per location without using clients in the table,…
- Answered
-
Export List of Pyramid User Accounts
Is there a way of exporting a full list of user accounts on Pyramid, along with related information (e.g. Roles, Profiles etc.)
- Answered
-
Notification of Publication Failure
Hello, Is there a way that users can be notified when a publication fails? I can see this previous question which showed there is a repository table to see this in BI Office,…
- Answered
-
What are the best practices with the new migration capability?
Hello, We are trying to use the migration utility to promote content from development to production. However, we are getting duplicate content suffixed with a number e.g.…
- Answered
-
Adding "All" to a slicer
HI this seems like it should be straightforward. I have a tick box slicer with numerical values which allows me to pick an "all" option. But I have another Drop Down which is Text items and does not,…
- Answered
-
Adding Countries to recognised countries
Hi Is it possible to add followig as countries? 1) Hong Kong 2) Macau Than you
- Answered
-
How to get the Content Path from the Pyramid Repository in Usage Reporting
In the usage report that I built based on Transaction logs in Pyramid, I am not able to get the 'Path' for my dashboard or report objects. Is there a way to get a path field for the content?
- Answered
-
IF formula trouble
I'm trying to do the following: If (Transaction Code = "NWP" OR "GWP",BLANK, (Measure - Amount/ Datapoint - Amount where Transaction Code = GWP)*-1) At moment this is a picture of my formula - I can…
- Answered
-
data retrieval
Hi all.... I have a query while making some modifications to my existing report My requirement is: 1. Have the stored procedure (with @year and @weekno parameters) to display weekly wise report for…
- 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
-
Switch dimensions in a bar/column chart
Hello, Is there any way we could switch between two dimensions in the categories of a bar/column chart? For example, right now we have a visualization prepared to show Financials by Accounting Year,…
- 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
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help