getAllConnectionStrings returning a 302

When I try to hit my instance of the Pyramid API 2.o to getAllConnectionStrings I am receiving a 302. How can I remedy this problem?

• Answered

Server Sizing

We are new to Pyramid 2018 and are trying to get an idea on server sizing, in particular memory and cpu, before we lock in our configuration in AWS. Our current config is: Processor:…

• Answered

Parameters don't seem to be working

I added a parameter to one of my dimensions which I also have in rows in my grid. I am not sure if I did something wrong, but when I change the selection in the parameter's drop-down,…

• Answered

How you change default Theme color combination ? only choice is row header setting color ?

How you change theme's default color combination ? ( If it is ugly color combination ?)

• Answered

What happened to sorting?

My experience previously was that I could have Elements show up in a report in the order I selected them. What I am currently experiencing seems to be it puts all "standard" Elements (i.e.…

• Answered

Publication - Slicers for email and display name

Hi, I have a publication that is distributed by email address, which is a slicer in the publication. I also use this email address in some dynamic text on the front page of the publication.…

• Answered

Alert email in PA2018

Hi team In BIOffice we had alerts (which could be send out by email) with dynamic text inside form a discovery. Is there a plan to implement those into PA2018? Thx

• Answered

Number Formatting in Discovery

Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…

• 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

Connect to SharePoint List in Data Model

Is it possible to connect to a SharePoint list as a source in a data model? I tried various options using the OData source adapter, but could not find a way to get it to work.…

• Answered

NQL and OLAP models

We noticed that natural querying and some other cool features (Time Intelligence, Clustering, Outlier analysis,…) don't work with OLAP models, but only within Pyramid-created models.…

• Answered

implementattion of chord chart in pyramid 2018

Hi Team, Do we have an option of implementing chord chart in pyramid 2018? If yes,can you please help me out on this? Thanks, Regards Manish

• 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

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