-
Dynamic Caption for prior month
Trying to use a dynamic caption to show the field name as "Net Written Premium to Feb-2023" I'm trying to get the Feb 2023 part using : Lag(StrToMember( [RiskExtract].…
- Answered
-
Restricting Access based on User rather than Role
Is there a way within Pyramid to restrict access to a content folder based on choosing specific users with access permission rather than by role?
- Answered
-
Applying conditional formats (colors) to elements for particular columns
Hello , Can you please help us on having color formatting to different elements in the column as shown in the screenshot? Regards, Aaron Y
- Answered
-
Auto rotate between mini tabs
Hi, Is is possible to automaticly rotate between mini tabs, in a similar way we can auto rotate between pages on a datshboard ? Tnx, Michael
- Answered
-
Dynamic list that returns latest four months based on current date
Hi there, I currently need help producing a dynamic list that can be imbedded into my 'GAAP Accounting Period' elements list which, based on the current date, selects the last four months.…
- Answered
-
Creating a dynamic parameter for a date range
Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…
- Answered
-
Bell curve graph
hi, the business is looking to use bell curve graphs in Pyramid to depict performance (using MEAN and Std Deviation and normal distribution). We are struggling to make it work, any insights welcome.…
- Answered
-
Data exclusion in Publish schedule
Hi I have a scenario where I have a sales publication going out to a lot of email recipients via a dynamic email list against a slicer with 3 entries. Let's say those 3 entries are "Cars",…
- Answered
-
Sourcing Reporting Services Output in a Data Model
Does anyone know if it is possible to use an SSRS output (CSV, XML, or Excel) as a source in a Data Model? We tried to use the URL option without luck but aren't sure if it is a security problem or…
- Answered
-
Group Measures Under Headings for Export
Good afternoon, We have a scenario where a client is exporting a grid to excel. The real scenario has many dimensions and measures on the grid. I have created a small example using the sample demo…
- Answered
-
Discovery Data Catalog Export
Hello folks. Is it possible to export the data catalog from a discovery object in a format which is not .pdf? I see I can export the data catalog from a data model object as a json file,…
- Answered
-
Data Mesh and Pyramid Analytics
Hello everyone, I was wondering how can I leverage Pyramid packages to implement a data mesh for an organization. I would appreciate it if you share your experiences. Thanks!
- Answered
-
How do I close "Analyze Further" after I use it?
I want to close the Analyze Further pane so I can see more of the report, how do I close it and keep the report open? Sorry if this is a newbie question but nothing works and there isn't anything in…
- Answered
-
Use single measurement as a fixed / set Measurement AND as a Dynamic Measurement at row level or in Calculation
Dear all How can I create a measurement with a set/fixed value that any filter or dimension will not impact? I am working in Higher Education, so my use case will be unique as it is not a commercial…
- Answered
-
Use of Tables in Present
Dear all I vaguely remember either a blog posting or a How to posting arriving in my inbox in late 2022, summarising the creative use of tables to summarise data.…
- Answered
-
Format Percentage in 100% Stacked Bar
I have a 100% Stacked Bar that I have turned on the Data Label and switched it to show the percentage. Can I format the percentage to no decimal places or just 1 decimal?…
- Answered
-
Convert measure to dimension & measure
Hello everyone. I'm seeking to create a dimension from a current measure column so that I have this column visible as both a measure and dimension. Cheers, Dave
- Answered
-
Comment modéliser mes données correctement
Bonjour à tous, je dois réaliser un reporting en fonction de ce fichier excel. Sur des graphiques, je dois afficher le nombre de journées CP en fonction du nombre de journées.…
- Answered
-
Which organization makes successful use of conversations in Pyramid?
Hi everybody, we see the potential of chatting in Pyramid but it’s behavior is less intuitive than we expected. Nevertheless we think that we can start using this functionality if we introduce it…
- Answered
-
how can i insert a 60 second pause before next iteration of while loop??
assume i need query result from table1 to equal query result of table2 before having a model "process". i thought there might be some sample pql statement that would be similar to "sleep 60" before…
- Answered
-
Line Banding, different bandings for different classes. Swap dimensions.
Is it possible to have a dimension switch similar to how we deal with measures, so a set of buttons to pick x or y dimension? The reason being I have a report which shows exposure,…
- Answered
-
How to un-show header in a table
Tableau had a feature that allowed you to add a column to a table but hide it by deselecting 'show header' Is there a similar feature in Pyramid? Here's a table I created in Pyramid and I could like…
- Answered
-
HR Cube - Absenteism hours - Formulate
PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…
- Answered
-
Possible to have an Embed Dashboard dynamically resize based on container dimensions?
We are using pyramid embed, due to the different screen size of users, wanted to know if it is possible to have the height and width set dynamically based on browser/container?…
- Answered
-
After focusing on a member in a Discovery, how do you unfocus?
Hello, We have had a couple of occasions where users have focused on something and saved the report. How do I turn off the focus so it goes back to it's original state? Thanks, Rob Clark
- Answered
Got stuck with a report? Start a discussion or help others to move forward.