Recent Discussions
Dynamic Calc UD8 Dimension to Filter Account Dimension?
Is it possible to create a dynamic calc UD8 dimension, that then filters down the members on the Account dimension at a base level? (and if so, how?) For example, within the Account dimension, I have Member A, Member B, Member C and Member D. Can I create UD8 dimensions of "Group 1" and "Group 2" where if Group 1 is selected, it filters down Account to only show Member A and Member B. And if I choose Group 2, it filters Account to only include Member C and Member D. I know this can be accomplished with an alternate hierarchy on the Account dimension but just checking to see if this can be done alternatively. Thanks in advance!
Zero Suppression Threshold with Unstored Data
Howdy I want to apply a Zero Suppression Threshold (of 1,000) in a Cube View for a specific column. However, the Account in my column is a Dynamic Calc. The suppression isn't working at all, can someone confirm if Zero Suppression Threshold is only available for Stored Data? If it is only available for Stored Data, is my best option to use a Member Formula instead of a Dynamic Calc? I've tried using Cube View Math as well but I get the same result as using a Dynamic Calc. Thanks in advance
BI Viewer | Pivot Grid Formatting on Export
Hi everyone! I am working with a Pivot Grid dashboard item in the BI Viewer. I am investigating about the possibility of formatting the Excel export of this component. Currently, the exported file does not retain the formatting applied within the BI Viewer, resulting in a very non-user-friendly layout, with fixed column widths. Are there any options available? Any insights will be highly appreciated! :) Thank you! Have a nice day, Andra
Best Approach for Exporting and Importing a Dashboard into a New Application
Hi all, What is the best way to export and import a dashboard into a new application? Do I need to select all its components every time, even if some already exist in the destination? I’ve noticed that if you select only the dashboard or the embedded version, the components don’t appear in the XML file. Thanks in advance!
Guided Reporting/Dashboard parameter WF Profile entity value defaulting to Parent
Hi all, I am implementing Guided Reporting into our workflows. The entity parameter I have is a member list looking up E#Root.WFProfileEntities. The cube view is a pretty standard balance sheet, with row and column sets. I have embedded it into the workflow, so that users can come in and use their reporting for the specific entities. The issue I have is that whenever I open the balance sheet and set the rows and columns, the cube view always defaults to the Group Parent entity, even if the WF profile has different assigned entities. I change workflow, and it still shows the parent entity. It's only when I change the entity manually from the GR parameter button that it refreshes. Any idea how to link the entity button to set the cube view upon first run? Maybe I'm missing something, or maybe there is a BR that I can build? Thanks!zero data row suppression with CustomMemberList member filter?
Hi, we have a custom member filter in a cube view (i.e. E#Root.CustomMemberList(BRName=X, MemberListName=Y)), and it seems to disable row suppression. In other words, the cube view brings back all filtered members in rows, regardless if there is data, even when the row suppression settings are set. Has anyone else experienced this and can confirm/deny? And if so, is there a way around it? We based architecture on CustomMemberList following the same rules as any other member filter. Jon
Report component - The control is overlapped
Hi guys, I need to create a pie chart on a report component (under dashboard), but this pie chart has the particularity that, instead of showing up the labels of the data presented in the chart itself, i need to show the Total Amount inside the pie. The achieve this, i wanted to add an XF label taking the total from the cube, but when i set the label over the chart then i have the error "The control is overlapped". Do you have any workaround / solution to allow the controls, in particular the labels, overriding a chart? note: ok under preview that works, but at the end i need to use this report component in a docx file (with narrative reporting) - that's blocking me to use the report. Thanks a lot in advance, Regards, FlorencePDF export - Header text wrap breaks indentation in CubeView
Hi, I have a CubeView with indentation applied on row members. When exporting to PDF, I need all columns to fit on a single page. To do that, some column headers wrap onto two lines. The problem is that the indentation works only on the first line of the header. When the header text wraps, the second line is not indented, which creates a misalignment. Has anyone faced this? Is there a way to apply indentation on all lines of a wrapped header in PDF export? Thanks in advance
