Recent Discussions
Reports using Multiple Cubes
Hello, Would it be possible for me to generate a CubeView using multiple cubes? I know it would be possible using an XFGETCELL since we have to point to the specific cube in the formula. We are currently utilizing a single cube with all the parent and base level members in our dimensions and are transitioning into 2 Cubes (1 for the summary/parent level and 1 for all base level members). Our existing reports for example A#NET_INCOME.treedescendantsinclusive would work fine in our single cube, but it may not work when we move the parent & base level members to separate cubes.bjornliow9 hours agoNew Contributor III6Views0likes0CommentsDynamic Point Label Format for Advanced Chart
Hello, We are currently creating a series of dashboards at my team and have primarily used Chart (Advanced) components as these fit our needs the most closely. However, one limitation we have come across is that sometimes it's more fitting to have the Point Label Format in thousands and sometimes in millions. Is there a way to make the component decide which format to use automatically? I suspect that it might be possible considering you can do the following to handle negative values and hide zeros: {V:0,,M;(0,,M);''} I was thinking one might be able to do something similar for different magnitude values. Thanks in advance!mireles12 hours agoNew Contributor III11Views0likes0CommentsV#VarianceExplanation - Best Ways to Use
Hi, I'm trying to understand the best way to add annotations and comments in OneStream to explain variances. Last week at splash I was advised to use V#Annotation or V#VarianceExplanation. But what I'm confused about is how do you actually get it connected to the calculated variance (red box), versus only being able to connect it so the actual reported number (yellow box). Right now I'm using a get data formula in my quick view to calculate the variance (GetDataCell(S#Actual-S#AOP):Name(Variance)). What are other people doing when trying to provide commentary on variances? Whats the best way to use this view?matthewsb41917 hours agoNew Contributor38Views0likes3CommentsBI Viewer component and OneStream 9.0.0
Hi all, We upgraded one of our OS instances to 9.0.0 After a first look, it seems BI Viewer does not work anymore from Desktop app, but charts are showing from Modern Browser interface, any idea? Can't find a clue on Know Issues. On Desktop app, only the layout shows, no content: Same Dashboard from Modern Experience shows fine (I blurred data here) Any advice?sylvainremy2 days agoNew Contributor II25Views0likes0CommentsHow 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!Solvedjayaleck3 days agoNew Contributor II53Views0likes4CommentsGet member description in user's culture code using excel add-in
Hi all, Do you know how to get the member description in a scpecific language using the Excell add-in? I suppose that it can be done using the "XFGetMemberProperty" but I can't find an example. Thank you. XFGetMemberProperty This function retrieves any Dimension Member property from the Member Properties tab in the Dimension Library. Note there are no spaces used when defining property name. XFGetMemberProperty(“DimTypeName”,“MemberName or Script”,“PropertyName”, “VaryByCubeTypeName”,“VaryByScenarioTypeName”,“VaryByTimeName”) As a reference when using BR: Get member description in user's culture code | OneStream Community Best regards, CarlosSolvedCarlosAlvear3 days agoContributor27Views0likes4CommentsHow 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?EG4 days agoNew Contributor II31Views0likes3CommentsCan'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?jackienajm7 days agoNew Contributor II498Views0likes4CommentsCan 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_VCC7 days agoNew Contributor III164Views0likes7CommentsDynamic 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!AC8 days agoNew Contributor9Views0likes0Comments