-
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…
-
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
-
User Wise Measure Format Setting
We are getting the different format of same measure for different users. For example - User 1 is having formatting to have absolute value for one measure ‘Policy Count’.…
- Answered
-
Multiple Attribute on Same Axis
When more than one attributes are required on the same axis for example if we have to show Country wise, year wise Premium then in PA 2018 it is showing as,…
- Answered
-
Color Formatting
Hi All, I have three goal example sat% less then 50 % - red color sat% >50 % and sat% < = 81% - yellow sat % > 81 % - Green color Please give me the steps Thanks in a advance Regards, Ranga Naik
- Answered
-
How to remove Present slider (Bottom right ,left arrow) if you have one slide to present ?
How to remove Present slider (Bottom right ,left arrow) if you have one slide to present ?
- Answered
-
How you can drill down from one report to another (sub report ) ?
Hi, How we can drill down from one main report to sub report. Example : Product main report ,and when you click on sub category , it will open another detail of subcategory report ? Thanks. Vijay
- Answered
-
How to hide Microsoft SQL databases that a user does not have access to
By default even if a user does not have access to an Microsoft SQL database they can still view it when logging into SQL Management studio. Therefore the same behavior will be seen in Pyramid when…
-
Formula Question
I am using an OLAP/SSAS data model and I want to create a formula to calculate the percent change between two different values of a specific measure based on the selected value of a specific…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community