Recent Discussions
Combo Boxes Passing Selections to Other Dashboards
Hi I appear to be having a slight issue when trying to feed the user selection of multi combo boxes embedded in the main dashboard to other dashboards that the user would be navigating to (i.e. their selection on the main dashboard would be the default in the next dashboard). I can currently only get it to work for one single combo box at a time? I'm using a Dashboard Extender Rule which incorporates both the LoadDashboard function type (this is activated against a server task for the dashboard being navigated to) and the ComponentSelectionChanged function type (this is attached to each of the combo boxes as a changed server task) Any advice on this would be much appreciated or if there is a easier way to achieve it? Thanks Andy
Preserve Excel Format
The Preserve Excel Format option seems to work for retaining formatting done in Excel when re-opening and refreshing cube views. However, I'm finding that my data is greyed out as if invalidated upon refreshing a cube-view in Excel after the initial connection. I've tried setting the font color to black and that was overridden upon refreshing as well, even though all other formatting is still intact. Perhaps there is a setting I am missing?
Accessing User Entered Data on a Dashboard CubeView
I have a dashboard with a cubeview. The user is allowed to enter data into multiple cells and then save. I have a save event handler to verify the data entered, however, I cannot access all of the information at one time. The event handler provides access to one cell at a time. Also,within each row I have a cell where users may change the numeric value and another where they type in an annotation. Changes to the numeric value cells will fire the event handler however changes to the annotation cells alone will not trigger the event handler. Is there any way to access the entire cubeview pre saved data to verify entries. I need to know that if a user entered a value that they also entered an annotation or if the user removed an annotation where a numeric value existed on that row.Viewing all Metadata and values in Cube View or Spreadsheet
I am attempting to create a view in a dashboard for users to be able to see all metadata for each row with that value. Essentially I need to recreate the "Data Records" Report in the database. I would prefer not to recreate it in SQL via a data adapter, instead use either a Cube View or a Quick view in Spreadsheet. For the Cube View I can't seem to display more than 12 of the dimensions and would need 16 in the report (Cube and View aren't needed those can be in the POV). For the Quick View in Spreadsheet putting |!prm_Entity!| returns "#ERROR - The member filter contains unresolved parameters" instead of providing some sort of dialogue box to select the member. Any suggestions on how to get all dimensions into a Cube View or how to use parameters in the Member Selection in a Quick View would be greatly appreciated. Thanks
Receiving this error - when running a period that has no data.
Trying to understand a little more about this instance. This message appears when trying to run a period that has no data. Some questions have emerged around: Can we customize this message? (Thinking no, it is standard OOB message describing what is happening). What is happening? Does the data require consolidating in order to be leveraged? Under what circumstances would you receive this message relating to dashboards?Cubeview combining two dimensions in a header row/column
I have a Cubeview that's Header rows are Entity/Account/UD2. I'm going to export to excel, but currently I get column A is Entity, Column B is Account and Column C is UD2. I'm trying to figure out if there is a way to make Column B be a concatenation of Account and UD2 when it's exported. Column C can be whatever or not at all.
