Recent Discussions
How do I return a range of Members?
We have a large flat hierarchy, members starting with Px_1000 to Px_9999. For example, P1_1000_27 Project 1, P5_1001 Project Yellow.... P7_9999 Project Bob. The numbers are unique (no two same number). We want a report that allows users to enter a "From" - "To" to pull back members in that range. For instance, only pull back members in the range "From" 500 To "532". Have an XFBR where I'm parsing the string, that's working, looping through and but only returning the number. The issue is that I need the entire string and description of the member. That's where I'm stuck. If anyone has done this before, would very much like know how you coded the XFBR. Thank you!jayaleck7 hours agoNew Contributor II15Views0likes2CommentsHow 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?EG14 hours agoNew Contributor II26Views0likes3CommentsCan't see all Application Reports
I have some users who can't see the Map Transformation Report under the Application Reports. I have check their POV (looks correct), can't find anything under Dashboard security. Anyone have any suggestions as to why they can view some but not all the application reports? The POV appears to be set properly and they can view the transformation rules other ways, so I don't think it's a security setting. At a lost, has anyone encountered this?jackienajm4 days agoNew Contributor II497Views0likes4CommentsCan 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_VCC4 days agoNew Contributor III153Views0likes7CommentsDynamic 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!AC4 days agoNew Contributor5Views0likes0CommentsComments upload template for existing data which is already loaded.
Hi Team, I have scenario where the data is already loaded to system and now i just want to upload comments for that data. How we can achieve this to upload the comments only not entire data again with comments. Thank you..!!Harshada_285 days agoNew Contributor10Views0likes0CommentsParameter Prompt Only on Specific Tab
Hello, I created a dashboard with 3 different embedded dashboards. 2 are non-cube views and 1 is a cube view. I would like my parameter to only prompt and be able to be changed when I select the third tab. Is there a way possible to accomplish my idea or am I stuck with the prompt happening when I select the dashboard? I've tried changing the dashboard types thinking it would default to what the other dashboards are but it still gives the parameter prompt on the first dashboard tab. Thanks, WillSolved23Views0likes2CommentsXFDoc - PPT dynamic calcs
Hello, Is it possible to add dynamic calcs (UD8 member) into an XF doc powerpoint? I am trying to create an XFCELL that uses a variance member in UD8. However, I keep getting 0 as the value. Also, is there a way for a user to see the settings/parameters once an XFdoc is downloaded from OS? I saw an example in GolfStream, but it's only the final document (or appears to be). Thank you!psc6 days agoNew Contributor III3.2KViews0likes6CommentsHELP! Microsoft excel is waiting for another application to complete an OLE action after 8.5 Upgrade
Hello Experts, We have a few users that are getting below error while trying to close Excel windows after OneStream upgrade. Error text "Microsoft excel is waiting for another application to complete an OLE action" Can someone share any insights or guidance on resolution here? Regards, NDNirmal_Daswani6 days agoNew Contributor II91Views0likes8CommentsZero 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 advanceMantis_Toboggan6 days agoNew Contributor II4Views0likes0Comments