Week 1 2025 on a Wednesday
Hi all, I am working on the 445 calendar and 2025 started on a Wednesday so into my Actual Data dashboard I do need to load the last 2 days of 2024. I have those days in the load file but they do not show up in the dashboard. In the CV I am using this set up: T#2025.base.remove(2025W53). Looking forward to any tips :)
How to Run BR on Cube View DB Component Selection Change
I have a dashboard with a cubeview in row one and a chart in row two. I want the chart below to change based on what the user clicks in the cube view. I was hoping when the user clicks a new cell in the cubeview it would trigger the "Selection Changed Server Task" action but I can not seem to get a rule to run there. Does anyone know how a BR on a cube view dashboard compoent is triggered? I was hoping on cell selection but maybe not. Thanks.MergeAndCenterColumnHeaders in Cube Views
Hi, Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views? We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view. There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks
Customizing aggregation weight
The client requires us that aggregation is with an average method and not summing (this condition must be applied to all dimensions). For example: Oversea and Europe are aggregating summing (UD4 members), however, the client requires that the aggregation make an average of their children. Note that in column we have metrics (account members) where we need to apply it. The result desired would be 5 %. Thanks in advance.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
