Connecting multiple Excel selections to Python script 'easily'

I want to use an existing Python function to do calculations on my data in an Excel file in Pyramid. The script uses multiple inputs from the Excel file,…

• Answered

URL Too Long when using an action to drive to another report.

Hello I've created a report which I want to use as a detail report. I create an action so that summary reports can drill down into the detail report using "cell".…

• Answered

Sqoop import to HCatalog/Hive - table not visible

HDP-2.4.2.0-258 installed using Ambari 2.2.2.0 I have to import several SQL Server schema which should be accessible via Hive, Pig, MR and any third party(in future). I decided to import in HCatalog.…

• Answered

Adjust default aggregation for date drill down levels.

I have a calendar hierarchy which when drilled down from Year to quarter aggregates by summing the months in the level below; I like this functionality but would prefer to be able to have it average…

• Answered

Filter Slicer content based on existance of measures

Hello, I want to create a slide in Pyramid which shows a table with a measure sales of the 12 last months. The measure Sales is connected to a dimension hierachy (Organisation: subteam, team,…

• Answered

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

Calculation turns wrong after drill-down

Dear all, the automatically calculated percentage (Create Measure – Percentage of total) calculation turns wrong, if elements of different levels are shown.…

• Answered

Cell bars are displayed incorrectly in case the Grand Total is switched on

Dear all, the cell bars' lenghts are related to the maximum value (which will then have the bar filling the whole cell). If the Grand total is switched on this will not be taken in to account, i.e.…

• 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

IMDB - Questions about modelling

Hi everybody, could anyone of you please help me to get things into order? I have two users A and B belonging to the same role and profile and having the same access to the available datasources.…

• 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

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

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

Latitude and Longitude

Hi, I am struggling to use Latitude and Longitude to plot data on a map. The data plots correctly with Country and State, however adding latitude and longitude causes pyramid to display nothing on…

• Answered