-
Problems with Custom Maps
I've been creating some map reports and I have a postcode hierarchy consisting of Country, Area, District and Sector. When in the hierarchy, the shapes don't change as you drill down.…
- Answered
-
Column Convert - from String to DateTime
Hello, I am using in a MODEL the column convert function. I try and convert a String into a DateTime format, but the feature does not seem to act consistently.…
- 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
-
Exporting as Data Items
Hi, Is it possible to export information produced (in any of discover, publish, present) where the underlying data is visible? Expanding on this, when, for example,…
- 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
-
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
-
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
-
Maintaining Formatting when Exporting to Excel
Hi all, New user here still getting to grips with the product. I am currently in the process of trying to replicate some of my company's reports that are in a standard format in Excel.…
- 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
-
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
-
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
-
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
-
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
-
CurrentPeriod & StrToDate in an InMemory Model
Hi, I created an InMemory model in which i have Date elements. When i try to use CurrentPeriod or StrToDate functions, syntax control is ok but result is empty,…
- 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
-
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
-
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
-
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
-
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
-
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
-
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
-
Left/Right Outer joins
Hello, I somehow struggle to get my Left/Right outer join working (see print screen). Could you please confirm the Left/Right refers to the fields below (in that instance, "Audit sans...…
- Answered
-
What URL'S does Pyramid need access to for mapping to work?
The Pyramid server (Run-time and Task engine) need access to: http://dev.virtualearth.net/REST/v1/Locations/ - this is used for Geocoding addresses, only address information is sent. and https://*.…
- 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
-
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
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
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