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.
Narrative Reporting
Hi, We have installed NRR and are able to upload documents. However, adding a cube view using the syntax is not working. Despite searching related articles and trying different syntax variations, the cube still fails to render: Syntax 1: {DOCVARIABLE "{XF}{Application}{CubeViewReport}{Abseentism_Rep}" "IncludeReportMargins=False" "IncludeReportHeader=False" "IncludeReportFooter=False" "IncludePageHeader=True" "IncludePageFooter=True""} Syntax 2: "{XF}{Application}{CubeViewReport}{Abseentism_Rep}" We are on V8.2.2, does anyone have any tips?Version 8 formatting issue with Books/Cube Views produced in Excel?
Just checking to see if anyone else has been experiencing the following issue with Version 8. We are currently testing the upgrade from 7.x to version 8 and have run into a huge formatting issue with our books that are produced to Excel and sent out to management via postal service. The source cube views for a batch use the same column template. We have Excel column width formatting set up for each of the columns (but consistently on each column). When the cube views are run and exported to Excel, the column width is not being recognized in most of the columns. I have tried direct formatting, I have tried with a literal parameter and getting the same results no matter what. I don't see where I can attach the workbook itself but am attaching a screen capture sample . In this case text wrap is set to False and column widths are set to 100. Note the results. Oddly, in like the first book, some of the sheets ARE recognizing the column width. I'm just wondering if anyone has experienced this and has found a workaround or determined why this is happening.
Journal report for multiple workflows
Hi All, We have a requirement to get journal report for all entities irrespective of which workflow was used to post the journals Example - There are different BU related workflow ( example BU M workflow )which has individual BU related entities assigned and there is another work flow - Central Group Adjustments which does not have any entity assignment. Users from BU M workflows would like to see all the journals posted viaCentral Group Adjustments which are related to BU M entities. We have different securities for each BU workflows andCentral Group Adjustments as well. Basically all BU users should not have access toCentral Group Adjustments workflow , but they would like see / view all the journal posted for respective workflow assigned entities. We can always have an option to give read only access toCentral Group Adjustments , but just wanted to check if there is any report which shows all the journals posted from another workflows as well ( assuming users have access to those entities but not the workflow) Thanks in advance, Cheers AJDashboard Report - calculating % on Group Sum values
Hi all, I'm trying to figure out how to insert a field within my report's Group Footer that would perform a calculation on other Group Sum fields. In my Group Footer, I'm summing up Contract Amount and Contract Margin fields from the Detail band. I would like to calculate the Margin % based on these sums and have no idea how this is done. Any advice would be greatly appreciated! CosimoBusiness Rule or UD8 Calculation in Place of Multiple Overrides
Hi! I am building a CubeView and currently exceeding the 4 maximum column overrides. To work around this, I am thinking the next best option is to build a business rule or UD8 calculation that combines multiple formulas but need help putting together the language (unfortunately, coding is not in my wheelhouse). Does anyone have a current business rule or UD8 calculation that I can utilize that subtracts one column from another for multiple criteria? For example, below is what I currently have in the Column Overrides. I think I would still need to put the UD8 calculation in an override because of conflicting GetDataCell formulas in my rows/columns but because there are various views (QTD & YTD) and scenarios (Actual & PYRates), ideally would need to combine some of the formulas together in the calculation as to not exceed the 4 maximum overrides. Hope that makes sense. All of the column references is a gross margin calculation. For example: QTD_CY = Current quarter gross margin (i.e. 2024M9) QTD_PY = Prior year quarter gross margin (i.e. 2023M9) QTD_CY_PYRate =Current quarter gross margin (i.e. 2024M9) + S#PriorYearRates YTD_CY = YTD gross margin based on current quarter selected (i.e. 2024M9) YTD_PY = YTD prior year gross margin (i.e. 2023M9) YTD_CY_PYRate = YTD gross margin based on current quarter selected (i.e. 2024M9) + S#PriorYearRates Open to all ideas. Thank you in advance!