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?
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 Selector List Label Incorrect Position
Howdy, When using Guided Reporting, the Selector List Labels are not being positioned correctly. As shown below, the label is positioned on top of the next parameter (to the right) instead of the parameter it's associated with. Has anyone experienced this before and have a solution? Additional information: Occurs in every report when viewing in Guided Reporting Global Selector List Labels are aligned as expected Thanks in advance Mantis
Basic Question about BI Viewer and Cube View MD data source Column Expression
I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product. In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column? I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid.
