-
Pyramid 2023.01 Released
Pyramid 2023.01 (Service Pack 1 for 2023.00) has been released. It includes a collection of fixes and multiple new capabilities. Software The main installer files can be downloaded from the Customer…
-
Pyramid 2020.29 Released
Pyramid 2020.29 (Service Pack 8 for 2020.20) has been released. It includes a collection of fixes for issues. Software The main installer files can be downloaded from the Customer Portal.…
-
How to: Add Link Backs from a Presentation
How to: Add Link Backs from a Presentation into Pyramid When sending out a Presentation to your users, it is very helpful to provide them a way to link back into the Application for further analysis.…
-
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