Cheat sheet for Formatting Syntax
Hi, Can someone point me to a syntax cheat sheet for formatting cube views and reports in Excel? I'm trying to get this number to show in thousands and have my negative numbers be in red with parentheses, and I'm super close, but I have this odd space at the end I can't seem to solve. ChatGPT got me here: ExcelNumberFormat = [#,##0,_);[Red](#,##0,_))] But it's stuck there.
How do I remove parameter prompts from WF?
I am using a Cube View (IS) within a dashboard. The client does not want users to be prompted with parameters for selecting Entity, Time, or View. Instead, they expect these dimensions to be driven automatically by the Workflow Point of View While I’ve successfully applied WF Time and View dimensions in the CV to align with the Workflow POV, I’m encountering an issue with the Entity dimension. It does not respond to the Workflow POV such sd WF, WFProfile, etc.. I either have to hardcode it, or use the Parmeter. Can I create a parameter that does not prompt a user make a selection?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
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
