Latest Activity

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

Creating a Moving Annual Average

Hi, I am trying to create a moving annual average of customers to feature on a graph I have i created in discover (please see attached). How would I go about doing this?…

• Answered

'select server for saving model drop down box' in Pyramid is empty

• 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

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

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

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

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

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

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

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