OneStream Community

rjgoss · 06-09-2022

Is there any way to do a GetDataCell in a Cube View or Quick View where the members are dynamic/based on some criteria? The formula below doesn't work, but hopefully give you an idea of what I wish did work. GetDataCell(SUM(E#TopEntityMember.Base.Whe...

User Input Values for Quick Views · 04-29-2022

Has anyone come across a simple way to incorporate user input values with a Quick View? Our users very much prefer the Excel Add-In with Quick Views and tend not to like the predefined nature of cube views. This has been one of the main sources of fr...

rjgoss

Are you logged in? If so, try refreshing the Quick View or Cube View. I don't know why, but sometimes you also need to click on a cell outside the CV or QV, then back on a cell inside it for buttons to become active.

rjgoss

According to the online documentation, there's not really one for this, but there is a workaround that can be done in Excel that works, but comes with a couple caveats. The steps are below and then the caveats.1) In Excel, go to File=>Options=>Quick ...

rjgoss · 07-14-2023

Yes, you can use Range and Mask type mappings within composite mappings. As for Lists, I haven't had a reason to try, so not sure, but it would be easy to find out, as long as you use the correct formatting.Composite with Range F#1234~4567:U1#ABCDCom...

rjgoss · 06-15-2023

Have you tried logging into the OneStream Okta portal first and then using the Okta stamp for ServiceNow?https://osportal.onestream.com

rjgoss · 06-05-2023

Carmina, sorry for the delay in my response. Yes, there is a Jira ticket: PF-27351. I have not seen any updates to this in the release notes in any version since when this was put in on 11/29/2022.

OneStream Community

User Statistics

User Activity

GetDataCell in Cube View or Quick View with Dynamic Members

User Input Values for Quick Views

Re: Running Consolidation from Excel with VBA

Re: Running Consolidation from Excel with VBA

Re: Transformation Rules

Re: ServiceNow link doen't work

Re: Task Scheduler not executing tasks