Latest Activity

Left outer join not working

Am working on creating a Model but left outer join returns no values even for the main query. Has anybody had this issue

• Answered

What/How are the actions coded? If, then logic, etc.

Are there resources I can be pointed to in order to better understand the implementation of logic in general? I'm interested in this as far as actions/Action Settings as well as implementing MDX in…

• Answered

How do you prevent business users from saving within the folder while allowing them to view the content/create new (personal) discoveries?

• Answered

Using Python or R to pivot excel workbook

We have a workbook which has a list of names, and then a column with their performance each week i.e. John Smith, 1,4,10,8,4,6, Finance, Analyst with column headers being name, week 1, week 2,…

• Answered

Accounting Grid

In BI Office, I was able to change the formatting on the accounting grid levels. Grid Tab-> Rows-> Accounting Grid. I could select Base Level, Level 1,2,3..etc and update fonts, borders etc.…

• Answered

Semi-Additive measures

Hi - i have a data source on premise that is OLAP. I know that using Pulse I cannot access OLAP sources and I must access relational data sources only (in our case MS SQL Server) - i have done this…

• Answered

How to set up Alerts via email

Hi, How do I set up the alerts via email? There is not option to in this section. It notifies me the email settings are not configured, How do I configure those?…

• Answered

Highlight(select) items with "shift" button and add them to grid

When you select several items using shift button, they will be highlighted in the elements/measure panel but when you execute the quesry they will not be added to the grid.…

• Answered

Make multiselect filters selections visible

Hello, Is there a way I can make the selections from a multiselection filter visible anywhere in Discovery/Present? Currently when I select 2 or more members,…

• Answered

Rank function

Hi Everyone, I am trying to use the rank function in Pyramid (similar to rank function in excel) to rank customers with highest revenue to lowest. The environment used is MS OLAP.…

• Answered

Discovery filter in URL

Hello I can filter a discovery with a filter in the URL, but I need to select all the members from my list, how do I do this? Thanks

• Answered

Change Axis Label Alignment

Hello, How can I change the alignment (align to the right or align in the middle vertically) of axis labels (showing categories) in a bar chart in discovery/present? Thank you

• Answered

Changing decimal places on percentage data label

I have a pie chart containing data labels for Values and Percentages, i want to change my percentages to 0 decimal places. Does anyone know how i would do this?…

• Answered

Remove tooltip

Hello, Is there a way to remove the tooltip that appears whenever you hover over a data point in discovery/present? Thank you

• Answered

Prevent New Public Content Folder Creation

In BI Office, a setting in the Admin Console (called Multi-Tenancy within the Networking settings) prevented anyone without admin rights from creating new "top level" folders under the Public…

• Answered

Anonymous members in chart

Anonymous members except for slicer i.e. in presentation if I show a pie chart. I only want to show the selected brokers premium against the whole, not all the brokers. This may already be possible

• Answered

Add Formulation Parameter as Presentation Slicer

How do I add a parameter to a presentation from the 'Add New Slicer' menu in Pyramid 2018? I am using version 2018.05.814. I only seem to be able to select cube columns,…

• Answered

3d charts in Pyramid 2018

Hi does 3D charts still an option in Pyramid 2018? I'm looking for a way to convert my column chart into 3D for better visualization. Thanks!

• Answered

Default Chart colors (White text on white background)

When creating a discovery any type of chart the default background and text appears white. This something that forces me to take a few extra clicks to find where the color needs to be changed in…

• Answered

Address within Maps

Hi, How do you pinpoint an exact address in the maps discovery in Pyramid? I'm trying to pinpoint the location of multiple offices for a company. The address are across multiple states.…

• Answered