-
List Variable in a Model
Hi, i created an model with a single value variable, it works perfectly. But when i change my variable into a list, my query finds no row. I think i don't use the good syntax.…
- 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
-
Creating a waterfall using deduction amounts
Hi I'm not sure if this is possible but I'm hoping to create a type of waterfall chart where you have the Gross Amount as the start point and then a series of deduction types (COM,…
- 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
-
V2020 Unable to set Chart data label to white font
Hello, I have migrated content from BIOFFICE to V2020. I can not set the chart data label to white font as I was able to in BIOFFICE. Here is a screenshot showing both discover views side by side:…
- Answered
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- 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
-
Can you drill down by column instead of cell?
For example i have a date hierarchy for years , quarters and months. The user want to click on inception date hierarchy and drill down from years to quarters so the entire presentation shows all…
- 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
-
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
-
Sort multi-select Slicer
Can we sort data of multiselect slicer(Filter)? I have 'Date' slicer. I want to show Date in descending order.
- 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
-
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
-
How to Implement Push Notification
Hi Any one tell that how to create Push Notification in Pyramid Analytics with details.
- 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
-
#run_time_error
In the attached screenshot u can see two tables "spares" and "SpareTypes" among multiple tables, the actual problem is while connecting those two tables with inner join getting error during run time…
- Answered
-
Coloring specific cells
Does PA has coloring option manually. For example if want differentiate negative sales from others
- Answered
-
Pareto Analysis
Hi, We need your ideas about Pareto analysis. Please share your opinion about this. When we put pareto calculation for unordered values, without ordering descending it doesnt show true results or we…
- Answered
-
How to get # of days between given two dates
Hi, How to calculate data difference by using formulas. Need # days between 2 dates such as "Request Date" was available in source and "Today date". Example :…
- 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
-
data retrieval
Hi all.... I have a query while making some modifications to my existing report My requirement is: 1. Have the stored procedure (with @year and @weekno parameters) to display weekly wise report for…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.