Additional argument in PALO.DATA function to omit hashtag (#) sign for data splashing
There are uses cases when data input on consolidated level is required and using # is only an additional step for end-user. PALO.DATA function should have an optional argument that would enable inputs on consolidated levels without using #.
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...
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 ...
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...