-
Dashboard Gallery: Retail Infographic
Dashboard Gallery: Retail Info Graphic Infographics are a sub genre of Dashboards designed for quick information transfer. This Info Graphic is built for a retail environment and could for example…
-
Dashboard Gallery: Financial Stock Analysis
Dashboard Gallery: Stock Data Visualization This example of a quick Visualization is based on our live connectivity from Web Data Sources Stock Data Visualization This Visualization shows a number…
-
Count of positive values in sub query
hi all, Can you please help me to reproduce the metric from PBI DAX calculation in PQL? the story is the following - at any time dynamically we need to have counted positive values within internal…
- Answered
-
Dynamic filter for various slides in the same dashboard
Hi, I want to create a Cube based dashboard with multiple slides. I want to add a country filter for all the slides but each slide it will show just the relevant countries for this specific slide -…
- Answered
-
Actions > Jump to Content
Good morning! Working on adding a drill through to a discovery (on two different discoveries in the last week actually) and when I "jump to content item" and include context,…
- Answered
-
Using cascading slicers/filters
Hey all, We have a hierarchal table like the one shown above with simple data in the table and this table is hosted in Redshift. When I do cascading slicers so 1 interacts with 2 interacts with 3 etc…
- Answered
-
Pyramid Community Weekly Wrap Up - August 11th
Dear Community, BI is a bit like cycling, not only does Bicycle start with the same letters (bad pun), its something that is easily learned, looks simple from the outside,…
-
Pyramid Learning Hub: New Course Grid and 2023 Update
New and updated Courses for Pyramid 2023! We have some exciting new content and functionally recently released on the Learning Hub including a new Level 2 certification as well as an enhanced course…
-
Use API's to extract data from a discovery
Hello, Is there a way to make an API call to export data from a specific Discovery? Thanks, Rob
- Answered
-
Send a separate Email containing the Password
HI All, Some clients have strict security policies and their practice for sending confidential data involves using distinct channels: never sending reports/data and passwords in the same message.…
- Answered
-
Suppression of Columns when Column is Filled with dynamic parent
We have a challenge that we cannot solve at the moment. THe data source is a Anlysis Services Cube. We have a parameter based on a Organization Hierarchy.…
- Answered
-
How to Create a measure from a dimension
I have a dimension for my custom Financial Calendar and I want to add a column to my Discovery which is filtered on Year to show the Max Period. When I try and use MAX(Data Point.…
- Answered
-
get a list of unique account_IDs from two lists
Hi, I have 2 lists of Account_IDs, some of them are found within both lists and some are only in one. I want to create a new list with unique account_IDs base on the combination of the two lists.…
- 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
-
How to view underlying query of a discover report
Hello, I am wondering if there is a way to view the underlying SQL query of a discover report? I am not finding the performance dialog in the bottom right of my screen.
- Answered
-
Congratulations – Level 3 Certified: Shaun Lamprecht, BICycleBI
Pyramid Certified Level 3 Announcement After a small summer break we are now back certifying our Users as Certified Pyramid Consultants in Level 3 Solution Design.…
-
Capacity limit to number of accepted lists in Discovery's Variable List Wizard
Is there a limit to the number of lists that can be accepted when building a Variable List using the Variable List wizard in Discovery. I am trying to add 47 lists, however,…
- Answered
-
Shapes & pattern from png or svg
Hey! I would like to make visuals, where the data point patterns or shapes are based on images retrieved from URLs. For example, I could have columns be patterned as country flags or company logos,…
- Answered
-
Mimic member logic within lists
Hello folks. I have a very handy variable list object which filters a large number of products into the end-user's desired internal product categories. I would like to now compute the percentage…
- Answered
-
get measure monthly count for last 12 months
I have a [Measure] and that I want to show it's trend on a monthly basis. Therefor I created the following logic: strtomember("[Date].[Calendar].[Date].["+ format(now()-1,"yyyy-MM-dd")+"]").parent.…
- Answered
-
How to print a Publication from a Dashboard
How to Print a Publication from a Dashboard In this Tip & Trick we will cover how you can embed a print button that allows you to print an existing Publication directly from your Dashboard.…
-
Custom Columns and OLAP Cubes
We just installed Pyramid 2023 in our development environment and I am in the process of test driving some of the new features including custom columns.…
- Answered
-
Member Security - return default if no rows matched
We are looking to apply a security rule to a table using member security. In our security table, there is a default row that should be matched to if the user does not meet the security rules.…
- Answered
-
Dashboard Gallery: Retail demo with Google Form
Retail Analytics with embedded Google Form for Write Back At a first glance this is a typical retail dashboard, as it would be used by a Sales Rep on their Daily visits to a number of stores.…
-
Pyramid Community Weekly Wrap Up - July 20th
Dear Community, in the middle of northern hemisphere summer its time to give you something new to play with. The next official Explore Pyramid challenge dataset is available now.…
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