Recent Discussions
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.
Creating a Conditional Statement within a Cube View
Need assistance building this logic in for two conditional statements to return a value. The logic reads if one row is greater than 0.20 and another row is greater than 0.20, then 0 is the cell value. If not, then 1 is the cell value. Please let me know if I can provide any additional details.
Carriage Return in Annotation data on Cube View
Hi All Does anyone know how to add a carriage return in Annotation text (if it's possible)? We have a Cube View with an annotation member that displays data. Currently the annotation text can take up most of the screen on some rows andit would be really useful to be able to enter a carriage return. I have tried Environment.NewLine, vbCrLf, \r\n, <br>
Report Book - Loop with a XFBR string
We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead?
