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

How to Implement Push Notification

Hi Any one tell that how to create Push Notification in Pyramid Analytics with details.

• Answered

Processing Multiple Models vs. One Big Model?

I use a number of Models, each with a specific job to do. A few models pull data into my warehouse from various sources, and a few models abstract different cuts of the raw data suitable for various…

• Answered

Page Repeater

Hi, Is it possible to apply the page repeater to a set of pages? I would like the report to repeat page 3 and 4 i.e. pg1, pg2, [pg3, pg4,] [pg3, pg 4].... etc. Regards Linda

• Answered

Can you use the same measure twice?

I'm sure I've seen this feature but i cant remember where so. Is it possible to to use the same measure and 2 filters to display different figures on the same axis of a graph.…

• 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

Coloring specific cells

Does PA has coloring option manually. For example if want differentiate negative sales from others

• 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