Recent Discussions
Suppression based on V#Footnote values?
Hi all, We have a CV that we want to suppress based on V#Footnote values but the suppression seems to ignore this column and only suppress based on number values. Is that true? Is there any workaround or any way to have OS recognize text as a value to base the suppression on? Any info would be helpful! Thanks!NicoleBruno13 hours agoValued Contributor4Views0likes0CommentsCan you use Parameters with the Excel Add-in or in Spreadsheet
I am trying to build a quick view where the Member Filter refers to a parameter but E#|!prm_Entity!| produces this error in Excel: #ERROR - The member filter contains unresolved parameters.Gert_VCC24 hours agoNew Contributor II36Views0likes4CommentsMergeAndCenterColumnHeaders 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. Thankskmd2 days agoContributor68Views0likes2CommentsGuided Reporting Selector List Label Incorrect Position
Howdy, When using Guided Reporting, the Selector List Labels are not being positioned correctly. As shown below, the label is positioned on top of the next parameter (to the right) instead of the parameter it's associated with. Has anyone experienced this before and have a solution? Additional information: Occurs in every report when viewing in Guided Reporting Global Selector List Labels are aligned as expected Thanks in advance MantisSolvedMantis_Toboggan2 days agoNew Contributor19Views0likes1CommentViewing 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. ThanksGert_VCC2 days agoNew Contributor II16Views0likes0CommentsReport Book - Loop with a XFBR string
We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead?JuleneDS2 days agoNew Contributor II62Views0likes4CommentsBasic Question about BI Viewer and Cube View MD data source Column Expression
I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product. In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column? I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid.KurtMayer2 days agoContributor107Views0likes5CommentsDashboard Scrolling
I am trying to get a dashboard to have a particular scrolling behavior that I am not sure how to do if it is even possible. A simple example of the ideal is below. In this ideal dashboard the dashboard will scroll horizontally only. The inner dashboard will individually scroll vertically. I can not seem to get the outer dashboard to only scroll horizontally, and when it does that outer horizontal scroll turns off it appears the inner vertical scrolls. I think I am asking for too much but was hoping to get some confirmation. Thanks.Sweez2 days agoNew Contributor III22Views0likes0Comments