Transparent color in Excel
Hello the Community, Currently working on the formatting in a cube view, we noticed that the Transparent color in excel isn't working, most probably because Transparent isn't a police color recognized in Excel. Do you confirm you have the same on your side and do you have any other workaround than setting the text with the same color as it's background? Thanks in advance, Florence
Narrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!Conditional format based on Row Member Name and Row Headers hidden
Hi the Community! I need to show, in a cube view, the subtotals of my rows, showing the dimension members presented in the Row1 header (I have 2 rows in this case). To achieve this, I built an UD8 dynamic calculated member and that works pretty well - when on the Row2 base members, then it shows the description of the members, if i am on the Total member, then it shows the member descriptions of the dimension which is set on the row 1). However, sounds quite basic, but I need to set another format on those subtotals, so I used the Conditional format based on the Row Member names (If RowE1MemberName ...), what is working perfectly fine, until I hide those row headers - in this case, then the conditional format doesn't work anymore ! How do you achieve this kind of basic requirement in this case? Any idea would be very helpful :) Thanks is advance, Regards, Florence
Bi Viewer - Totals in Pivot table - Cube View MD
Hi All, I have a Bi Viewer dashboard where the total for the "NET ASP" column (grey row) is the sum of the submembers. However, this is not correct for the totals [Net Sales / Net Units]. But I'm not really sure how to do it with the current data adapter, Cube View MD. Just some FYI - The first level of the rows is the products, and the second is the market. Did anyone ever face something like this? Thanks, Davide
Calculate based on Text4 field
Hello, We are creating a cube view where the columns are dynamically filtered by the text fields of Entity and UD1. I am fairly confident in building a business rule to return the correct result, but I am uncertain of how to then present that in a "totals" column within the cube view. What type of business rule should I use for this? Once I create the business rule to calculate the value, how do I get it to display in a cube view column? (extender rule, dynamic calc, etc.) Any help or guidance on this would be much appreciated.
Cube view total row
Am i just missing something or is there not a simple way to produce a total row in a cube view? I have one row that pulls a list of accounts based on a combo box selection. When I try to use GetDataCell(CVR(Row1) it only brings me the total for the first line in that 'row'. I feel like there should be an out of the box option to grab the total of row 1 that may have multiple accounts.
Format Cube View based on third Header Override expansion
I am using header overrides on my columns to create three column expansion levels. I need to add conditional formatting based upon the header display text of "HPU" in this third expansion so that only sections with "HPU" in the header are set to three decimal places. I do not want to build every HPU column separate from the others, as this would require the build of 108 columns, instead of 12 columns. The system will not let me call that third expansion level in my conditional formula. Any help would be greatly appreciated!Export Cube View to Report Format?
Does anyone know if there is an api to export a cubeview to a report format, similar to how BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile can be used to export a cubeview to Excel via code? I want to get rid of the menu options so users can not use the normal save button but instead a custom dashboard save button. However, I need to find a way to replicate the export options that will also be removed. Thanks.
