Questions & Answers Category

Publications with Discoveries across pages?

HI, I have a Discovery with a number of charts that in a publication will go across multiple pages, how do you paginate a Discovery in a Publication?

• Answered

Can Admin see which reports Users have accessed?

Hi, Can the admin account see which reports specific users have accessed? Often times client users will ask me questions, but I don't know which report they've looked at specifically.…

• Answered

Mapping challenge

Hi I want to build the map with "VILLE", "ADRESSE" items that are in my data set on attached file. But I would like when the user open the map, the map stay only on Lyon city ( Ville).…

• Answered

How to remove Grid header deatils

I am showing data on below calculated grid and i don't want to show the grid header in presentation. How can i remove or hide this grid header details ? Regards, Mangesh Desai

• Answered

Calculate difference from two table on presentation

I have below two table on presentation and I want to calculate difference between Grand Total. Please See below screen shot:

• Answered

How to set Custom Order

I have working on one report and below is my result In above result Physical_Stock columns data suppose to show in below order: 0-30 31 - 60 61 - 90 91 - 120 121 - 150 151 - 180 181 - 360 How can i…

• Answered

map customization

Hello everybody. I'm asking if it is possible to change the by default coloured circle for dimensions put on a map. I'd like to point on a map adresses in a city.…

• Answered

Conditional Formatting

I have been converting reports from BI Office to Pyramid 2018 and I have run into a snag. Note that this report was imported from BI Office to Pyramid 2018 using the conversion tool.…

• Answered

Using Time Intelligence Hierarchy (Regular) cannot use a separate year filter

Hi I have a hierarchy showing values by year, which then the user can use the regular hierarchy to drill down to quarter, then month then date. Works perfectly however if I add a filter to the…

• Answered

Call Stored Procedure

How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?

• Answered

Model running but no discovery building

Hi we've just upgraded to 2020, and looks great! however when I'm running a model built in prior version it runs through perfect and says no issues but it won't load up the discovery for the model?…

• Answered

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