Latest Activity

Adding more than one hierarchy level to a discovery

Is it possible to include more than one level from a hierarchy in a discovery? I need to show both City and State but as they are in the same multi-level hierarchy I can't add both.…

• Answered

Formating line chart series

When I try to set dashed line and data labels for only one series in line chart with roght click on item in the legend. That work for only one series and formating is not aplied to selected series,…

• Answered

Percentage of row total

Hi Is it possible to do percentage of row total ? I can see percentage of total but not on a row basis? Thanks Nick

• Answered

Seamless page loading

First of all, sorry for the bad terminology used here. I have no clues on what the thing I try to explain is called. Let me try: I recently see a lot of nice websites being build with a "seamless…

• Answered

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