-
'Lagging' Time-Scale in Discovery
Hi all, Please see attached screenshot. I am trying to build a section of an existing report at my company in discovery for export to excel (for the time being).…
- Answered
-
Regarding color formatting
Hi All, Is there a way to create kpi such way that color need to change on the present quarter data based on the present quarter goal rest of the quarter data should not change .…
- Answered
-
Multiple Unions in the same model
I have a model that unions 2 different groups of data. If I remove the second union, the model runs fine, if I add another everything but the target in memory fails with no error but the status…
- Answered
-
Removing blank member from set [SSAS Tabular 2017]
Hi, When using the Time Intelligence wizard, the Last 3 years also includes an empty member. This is a cube/MDX thing rather than Pyramid 2018 specifically,…
- Answered
-
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
-
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
-
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
-
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
-
Standard Deviation
Hi Team , How to calculate standard deviation of a measure or metric considering last 26 weeks ? Regards, Ranga Naik
- Answered
-
Time Intelligence in Pyramid 2018
Is it possible to get preceding 7 days of full week result or filter in Pyramid 2018? For example, when one date is picked, report should show results for the current week (the last 7 days).
- Answered
-
External Parameterization
There are 3 issues regarding this - 1- How to filter presentation using external parameters 2- How to save slicer values in any additional db/system so that when report will be reopened then those…
- Answered
-
Viewer License
When we are login in PA using viewer license, user is not able to see the available slicers in the presentations. Please confirm what all the limitations with Viewer license.…
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help