Drill By is a great new function to jump into an ad hoc analysis from anywhere. At the moment, the dimension that is displayed on columns is predefined in the view. Which dimension is displayed as the column dimension is determined by the rules de...
Aggregate lists of elements for each dimension in PALO.DATA functions instead of single.
A PALO.DATA function refers to single base or consolidated elements for aggregation. It would be fine to be able to define subsets of elements to get a sum of these,
Beside selecting a date from the datepicker, the input field should also be filled manually without selecting from the datepicker. So the user can choose if he wants to select the date from the datepicker or if he wants to enter the date manually....
In many reports I need to consider date intervals. for example beginning is
2012-11 and end is 2015-03
Calendar is
- All Years
- Year
- Quar.
- Month
So a macro calculates all needed Elements:
- 2011-11, 2011-12, 2012, 2013, 2014, 2015-Q1...
Currently one has to create a conditional formatting to implement alternating row colors. As soon as rows are dynamically hidden or extended (e.g. drill-down in DynaRange), the alternating row colors are broken. Just like the frame of the DynaRang...
workbook export macro function should also support pdf as file type (currently xlsx, wss)
I am using macros to export files.Currently I can only choose between xlsx and wss.For a project I do at the moment I would need Pdf to be a possibility as well. why Pdf in this case?- normal users can't handle wss- we don't want the user to use a...
PALO.EPARENT and PALO.ELEVEL relative to specific root element (parallel hierarchies)
PALO.EPARENT and PALO.ELEVEL work well if you have only 1 hierarchy within a dimension.
But if you have more than one hierarchy it would be great to give a certain root element as parameter and get the parent and or the level in exactly this sp...
Give description of Password policy inside User Management
Recently, we introduced a password policy for users. On the platform itself nowhere is explained how the policy should look like. Users need to google or check in KB for that information. It could be a small display below or icon "i" where on the ...
Export a web report to Excel through dimension (bursting)
The result is an Excel with as many sheets than elements in the dimension. It allows to get reports split by channel or Customer or product without creating views manually.