Recent Discussions
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
Update make dashboard table formatting dynamic from BR
Hi everyone, I currently have a dashboard that shows the following table: the format of each field has been set in the SQL Table Editor settings, to allow the users to understand what fields can be updated. Nevertheless, I would need to make sure that the format of certain columns changes depending on how the users populate the table. For example, if the user inputs "MANUAL" under the col TAG, I would like the field "New Target Account" to become yellow automatically upon saving. So far, I only managed to make the content of the other cells dynamic using this construct in the Dashboard Extender BR linked to the SQL Table Editor: xfrow.ModifiedDataRow.Item("T_ACCOUNT_NEW")= "-----------------" Is there something similar that allows to also change the formatting of the cells? Thank you!
get partner currency in a cube view or FX formula?
hi all, good day; we are using plug accounts and IC matching accounts property, we see the IC matching report but I would like to know if it's possible to get the partner currency in a cube view or though a fx formula in Excel? I konw that this is a derivated data, but would like to know if its available on any dimension or fx formula Thanks in advance and kind Regards. Mario GuerreroBi 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, DavideBi Viewer - Hierarchy display
Hi All, I'm struggling with the Bi Viewer pivot table. I'm trying to get a hierarchical view on the rows for our UD2 - Market dimension. I have to use the Data Adapter Cube View since I have some calculated fields that cannot be replicated using the Cube View MD. Has anyone had the same issue? 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.Genesis Parameters (Filters) Issue
I am having an issue with cube view parameters within the Genesis content block "Cube View Comments"? I receive one of two errors - (1) Index was out of range (parameter 'index') or (2) Parameter is not supported. However, if I put the exact same cube view in the "Cube View Advanced" content block, the parameters work exactly as expected. Is this a bug or is there something I'm doing wrong? Any help would be greatly appreciated.
