-
Pyramid 2018.05.1 Released
The January 2019 release of Pyramid - build 2018.05.220 - includes several new features and numerous fixes. Upgrading Instructions for how to run the upgrade can be found here.…
-
How to combine elements under single header
Hi all, I am looking to combine a group of elements (R1, R2, R3) to create element R which I can use in a Discover Matrix Grid. If I add R1, R2, and R3 to a list then my list of elements looks like…
- Answered
-
Error connecting to MongoDB
I'm trying to join to MongoDB, unfortunately unsuccessfully. ERROR text: "Failed to open connection 'Unable to load authentication plugin 'org.mongodb.mongosql.auth.plugin.…
- Answered
-
'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
-
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
-
Pyramid's Calculation Engine Explained
Pyramid includes a sophisticated, multi-tiered calculation engine designed to handle the full spectrum of calculations often required in solving analytic questions and problems.…
-
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
-
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…
-
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
-
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…
-
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
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