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
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.
