-
Count members in List - for date ranges
Hi, I have a bvery basic list of dates, using a datefro mand date to parameter. I am trying to make a measure of the count the number of dates in this list,…
- Answered
-
Transparency doesnt work ? (PA 2018 04.460)
Dear Colleagues, first of all, i just registered to the PA Community so please help me to orient myself if this isn´t the right place for this kind of question!…
- Answered
-
Connect, VPS
when pulling a report for ICB for staff listed Connect, vps comes up.. why is that and what is this data? thank you
- Answered
-
2018.05: "Loosing" view of (Pie)Charts with small sizes
Hi, after updating to 2018.05 and checking my reports, I found out that Charts (in my case pie charts) now won´t be displayed in presentations if the object size falls below a specific value (see…
- Answered
-
Connection to Azure Analysis Services
Hi, Is it possible to connect to Azure Analysis Services OLAP cube directly from Pyramid 2018 or do we need to install Pulse server to connect? Thank you, Uroš
- Answered
-
Pyramid 2018.04 Released
August 2018 Release The August release of Pyramid includes over 100 new features and numerous functional upgrades and fixes, designed to make Pyramid’s Analytics OS the leading solution for customers…
-
Pyramid 2018.05 Released
December 2018 Release The December release of Pyramid includes over 50 new and upgraded features and numerous functional upgrades and fixes, designed to make Pyramid’s Analytics OS the leading…
-
Variable Set with a string search
Hi, Is there a way to set a variable with a string search ? We have used the process described here : https://community.pyramidanalytics.com/t/k9matw/variable-set-with-a-string-search before moving…
- Answered
-
Increase gauge size - Too much whitespace/real estate
Hi, I'm adding gauges to a new presentation, but I'm finding that they take up too much real estate. The gauge might be X width, but then either side is loads of whitespace.…
- Answered
-
Errors Embedding
We are getting errors while trying to use embedded Pyramid. Page is built following your samples. Login is successfully executed and stored in cookie. On load of div or execution of dynamic script…
- Answered
-
SSO
We're trying to figure out how to set up Single Sign On with Pyramid 6, using either CAS, SAML, Shibboleth or something similar. Is there a way to do that or is that a feature that will be added in…
- Answered
-
Missing data point/label in Geo Map new 2018 Pyramid ?
Can not find option to add data point in Geo map . any idea in Map how to add data point /label ? Thanks Vijay
- Answered
-
SQL Query in Model
Hello, I am trying to set up a SQL Query in a MODEL, but I do not understand which table name I should include into my SQL query. See both print screens attached. Sincerely Clément
- Answered
-
Setting up security roles for Analysis Services with Pyramid
Pyramid's security integration with Analysis Services is tight - allowing customers to securely query OLAP cubes or Tabular models and use any data level security definitions that have been included…
-
Line in Discovery
Hello, 2 questions regarding discoveries : - is there a way to inject fix lines (indicating value thresholds) like y(x) = 3 ? - how can I display on the same graph 2 lines sharing the same Y-axis…
- Answered
-
Outer Joins
Hello, I am trying to use an Outer Join matching a visit_code in 2 tables (see print sreen 1). I've set up my join as a Left Outer Join (see print screen 2).…
- Answered
-
How to use "Custom Colors" in the "Color" Drop zone to set a specific color to a specific value in a grid.
1) Create a new formula in the formulations app 2) Create an "IF" statement based on a measure using the "RGB" function and save it. Use an RGB Color picker such as the one here to get the correct…
-
GetElement Formula
Hello, I am trying to get the value of an element based on a function (see print screen 1). I however get an error that I do not understand. (see printscreen 2).…
- Answered
-
How to get text output from dynamic text?
Hello, I'm trying to create a dynamic text that would produce a different text output based on the country that the publication is scheduled for. I can get this to work with numeral outputs like…
- Answered
-
External power bi reports
Hi All , Can we see or call the reports of Power Bi which are running in power bi server inside pyramid Regards, Ranga Naik
- Answered
-
Reset Presentation Slicers to "All"
Hello Pyramid Community, I tried some different settings for the slicers on a presentation. Now, I always have the first available value of the slicer selected when I execute the presentation (I…
- Answered
-
Hiding label
Hi All, I am using two measures sales % and target sales % in primary axis i don't want label for red color line i.e target sales% how to hide the label for red line And red line i want make solid…
- Planned
-
Default Slicer/Filter member ?
How you can assign default member to Filter /Slicer in Report ? Example : always open in current month in Month Slice (Filter)
- Answered
-
Standard Deviation
Hi Team , How to calculate standard deviation of a measure or metric considering last 26 weeks ? Regards, Ranga Naik
- Answered
-
Pyramid 2018.04.460 - Interim Release
This interim release includes a few small feature upgrades and addresses a number of bugs. IMPORTANTLY: This version of Pyramid 2018 is designed to work with the BI Office Converter utility beta…
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