Latest Activity

One Publication, Two Servers/Data structures, One Slicer?

I have two main data sources -- two databases on two different servers that have related information, but "close, but no cigar" data structures. Is there a way to make a "dummy" data structure for…

• Answered

can we refresh chart or grid data automatically at run time?

I have created presentation to show chart and also created scheduler which updates the model every 5 min. I am not able to see the updated data on the presentation.…

• Answered

Ho do I cascade from one slicer to another, and have the second slicer have all options selected by default?

We are looking at student information at our university. I have set up a cascading slicer so that when I select a student then the second slicer populates with the courses they are taking this…

• Answered

Calculator symbol on Measures

Dear all, what is the meaning of the calculator symbol on measures? First I thought, the symbol indicates that the measure is a calculated one, but I've seen that symbol on "orginal" measures as…

• 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

Cloud Server Quick Start

Any plans for PA2020 Cloud Server Quick Start image on Azure?

• Answered

Removing Eliminations.

Hello, When using eliminations, in the ribbon there is an option to remove eliminations. Also available in the wizard as well, you can hit the cross on an elimination.…

• Answered

Is there a way to search through a list of cubes for specific key words?

• 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

Duplicate Discoveries in Presentation

Hi guys, I am trying to create a presentation comparing the same discoveries and dynamic text side by side, driven by separate slicers. Is it possible to use the same discovery multiple times in the…

• Answered

query a report between dates

Hi, how do I add a simple date filter in order to run a report between dates for example: get all results between 15/10/2017 - 25/10/2017 in pyramid 2018 thanks, Liav

• Answered

Limiting Results to All Data After x/xx/xxx Date

How would I go about limiting the data with a date value of, say, May, 20,2016 and beyond?

• 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

Creating multi-charts

I'm wondering how to combine charts into one plot. Currently, I have a time dimension on the x-axis, and I have two values I want to have on the y-axis (think "desktop minutes" and "mobile minutes"…

• 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

Batch Processing// Multi Threading// Parallel Processing

Hi Team, Its quite evident that we can have the ETL created and scheduled in the tool Itself. And not only one but multiple ETL's i one place rather than using SSIS packages.…

• Answered

Publish email with attchment

Hi team I created an publication and scheduled it. (The output format is pdf or word - still under review which works best). I want it to be send by email and the document to be attached to the…

• 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

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 call existing formula in a new formula

Hi I have one scenario that is create one new formula as "Pyramid High or Medium or Low" based on values from existing formula. Existing formula name is "Annual Sales" New formula as "Pyramid High…

• Answered

calling stored procedure dynamically

can any one suggest how can we call stored procedure dynamically, my actual intention i want to display 52 weeks data using a stored procedure, but in data model i don't want to pass any static…

• 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