Receiving this error - when running a period that has no data.
Trying to understand a little more about this instance. This message appears when trying to run a period that has no data. Some questions have emerged around: Can we customize this message? (Thinking no, it is standard OOB message describing what is happening). What is happening? Does the data require consolidating in order to be leveraged? Under what circumstances would you receive this message relating to dashboards?
Guided Reporting: Delimited List displaying Value Items
Hi I'm using Guided Reporting to generate a Cube View. Within the Cube View, a parameter (delimited list) is used to show / hide columns. This is working fine. My problem is that in the Selector List, Guided Reporting is showing the Value Item (of the Delimited List) instead of the Display Item. For example, an end-user will select 'Collapsed' (Display Item) but Guided Reporting will show 'IsColumnVisible = CVMathOnly' as the Display Item. This isn't impacting report functionality, however it looks messy.
Customizing aggregation weight
The client requires us that aggregation is with an average method and not summing (this condition must be applied to all dimensions). For example: Oversea and Europe are aggregating summing (UD4 members), however, the client requires that the aggregation make an average of their children. Note that in column we have metrics (account members) where we need to apply it. The result desired would be 5 %. Thanks in advance.
Preserve Excel Format
The Preserve Excel Format option seems to work for retaining formatting done in Excel when re-opening and refreshing cube views. However, I'm finding that my data is greyed out as if invalidated upon refreshing a cube-view in Excel after the initial connection. I've tried setting the font color to black and that was overridden upon refreshing as well, even though all other formatting is still intact. Perhaps there is a setting I am missing?
