User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Create post
Q&A
Latest Activity
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
Got stuck with a report? Start a discussion or help others to move forward.
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Status
Answered
Unanswered
Tags
Search
Follow
0
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…
anonymous client
quantenabler
3 mths ago
2
replies
32
Last reply
Michael Raam
Top Contributor
2 mths ago
Q&A
Answered
Answered
0
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,…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
3 mths ago
3
replies
26
Last reply
Ian Macdonald
Admin
3 mths ago
Q&A
Answered
Answered
0
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…
Yvonne Teng
Customer
Yvonne_Teng
3 mths ago
4
replies
40
Last reply
Ian Macdonald
Admin
3 mths ago
Q&A
Answered
Answered
0
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…
Nosikaa JOSIA
Financial controller
Nosikaa_JOSIA
updated
4 mths ago
4
replies
54
Last reply
Laurent Jamet
2 mths ago
Q&A
Answered
Answered
0
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?…
Jeremy Willes
Customer
Jeremy_Willes
4 mths ago
1
reply
37
Last reply
Ian Macdonald
Admin
3 mths ago
Q&A
Answered
Answered
0
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
Robert Clark
Top Contributor
Robert_Clark
4 mths ago
4
replies
41
Last reply
Ian Macdonald
Admin
4 mths ago
Q&A
Answered
Answered
0
Discover: sort isn't working as expected
As shown above, sort is set to order by the average score measure, however the visual is still showing bars not sorted properly.
Yvonne Teng
Customer
Yvonne_Teng
4 mths ago
3
replies
43
Last reply
Yvonne Teng
Customer
4 mths ago
Q&A
Answered
Answered
0
How to reset running total by a dimension value
We want to create a running total over time for each state and we want it to reset for each state. If I create a running total quick calc off of an existing measure it totals across all states.…
Robert Clark
Top Contributor
Robert_Clark
4 mths ago
3
replies
36
Last reply
Robert Clark
Top Contributor
4 mths ago
Q&A
Answered
Answered
3
Make reports with no longer existing measures editable for a viewer license
We have some year based measures that our viewer users use in their reports. For example these measures are always provided for the last three years (e.g. list price 2020, 2021 and 2022).…
Dominique Nowak
Customer
Dominique_Nowak
updated
4 mths ago
1
reply
32
3
Last reply
Ian Macdonald
Admin
4 mths ago
Q&A
Answered
Answered
0
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
Jeremy Willes
Customer
Jeremy_Willes
5 mths ago
1
reply
57
Last reply
Itamar Birenzweig
Admin
4 mths ago
Q&A
Answered
Answered
0
Predictive Modelling Use Case Problem
Hello everyone. I'm having problems working through the Predictive Modelling case study. All is going fine until I get to Step 2. Training The Model, Part 4.…
Dave Carbery
Partner Certified Level 3
Dave_Carbery
5 mths ago
2
replies
53
Last reply
Lara Grysczyk
Partner Certified Level 3
4 mths ago
Q&A
Answered
Answered
0
Optimizing a Star Schema Data Model
Is there any best practice documentation or tools available for optimizing star schema data models in Pyramid?
Elaine Charboneau
User Certified Level 1
Elaine_Charboneau
5 mths ago
5
replies
47
Last reply
Irad Gillett
Customer
5 mths ago
Q&A
Answered
Answered
0
Slicer ID Embedded Content
Hi We are building a website in which we use embedded dashboards. We are looking to build some sort of bookmark/favorites solution on top of it, which would allow the customers to save the slicer…
Yakov Shor
Top Contributor
Yakov_Shor
5 mths ago
4
replies
45
Last reply
Yakov Shor
Top Contributor
5 mths ago
Q&A
Answered
Answered
0
Distinct Count if Line Size Value >= Max Line Size for Group
Hi So I have a measure showing count(distinct aggregate reference) and it works as expected but now I need to only count if the line size value is greater than the maximum size allowed for the…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
5 mths ago
2
replies
66
Last reply
Nicholas Campbell
Top Contributor
4 mths ago
Q&A
Answered
Answered
0
import a .pie file
Hello everyone, I'm quite new with pyramid and I'm working through through the newby badges. I have started the level 1 formulate course and have stalled at the first fence...…
Dave Carbery
Partner Certified Level 3
Dave_Carbery
updated
5 mths ago
1
reply
25
Last reply
Rory
Community Team
5 mths ago
Q&A
Answered
Answered
0
Retain standard deviation values when removing a column
Hi there, I currently have the following grid: I'd like to attain a grid that doesn't include the Development Month column but retains the standard deviation result (shown above) for each department…
Benjamin Reed
Customer
Benjamin_Reed
5 mths ago
2
replies
35
Last reply
David Gordon
Community Team
5 mths ago
Q&A
Answered
Answered
0
Using MIN in formulate but only where > than another value
HI I am looking to create a box and whisper chart, I have got it working using Min / Max and average however we have a lot of Min entry where the value is 1 or 0, so the min is always near zero.…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
5 mths ago
1
reply
29
Last reply
Ian Macdonald
Admin
5 mths ago
Q&A
Answered
Answered
2
Models and alternatives to “scheduled” time to process
Outside of pyramid analytics I “know” when my data is available (that my model needs to downsample and append to an memory database) rather than having the model run at specific time of day can I…
anonymous client
quantenabler
5 mths ago
2
replies
39
2
Last reply
NPANS
5 mths ago
Q&A
Answered
Answered
0
total filter but without the dimension in discovery.
Hi I have a discovery where I have a set of premium values by reference. I want to exclude any reference where the premium value is above a set value. This is possible using the total filter which…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
5 mths ago
2
replies
50
Last reply
Nicholas Campbell
Top Contributor
5 mths ago
Q&A
Answered
Answered
0
legend location
i like having discovers render "legend" centered on bottom. when i try to add the discover to present or publish i only see legend on left, right, or off as options.…
anonymous client
quantenabler
6 mths ago
2
replies
26
Last reply
anonymous client
3 mths ago
Q&A
Answered
Answered
0
Retaining unique row combinations from query preview to discover
Hi there, In my SQL query preview section (first screen grab) which has two columns, 'Section_Reference' and 'Max_NSP_24Months', I have unique row combinations.…
Benjamin Reed
Customer
Benjamin_Reed
updated
6 mths ago
2
replies
44
Last reply
Ian Macdonald
Admin
5 mths ago
Q&A
Answered
Answered
0
Pyramid Analytics API
Good Day. I would like to connect Excel to Pyramid and extract a database using the REST API's. Is there any guidance on how to use these APIs?
Aadhil Khan
Partner Certified Level 2
BI Consultant
Aadhil_Khan
6 mths ago
6
replies
64
Last reply
Christian Langmayr
Admin
6 mths ago
Q&A
Answered
Answered
0
Existing or custom area chart with measure for x axis.
This is quite obscure so not sure if possible, but is it possible to create some sort of stacked area chart where the X-Axis is a rank (so numeric) instead of a dimension (so 1,2,3,4,…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
6 mths ago
4
replies
47
Last reply
Avi Perez
Admin
6 mths ago
Q&A
Answered
Answered
1
how to create not a dynamic calculation
Hi, I have a case where I need to make the next calculation: In a table with the columns: week | store name | item name | sales For each item: In each store,…
Maria Rozenblit
Customer
Maria_Rozenblit
7 mths ago
4
replies
62
1
Last reply
Maria Rozenblit
Customer
6 mths ago
Q&A
Answered
Answered
2
PDF / Document files as a Data Source in Modeller
Hi Avi / Pyramid Dev team, Often, information useful for a Pyramid client is stored in PDF or other document formats - for example where the Pyramid client itself has many suppliers who do not…
Richard Varley
Partner
Richard_Varley
updated
4 mths ago
2
replies
48
2
Last reply
Richard Varley
Partner
4 mths ago
Q&A
Answered
Answered
1
2
3
4
5
25
Next
Ask a new question
Got stuck with a report? Start a discussion or help others to move forward.
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help