OneStream Platform Forums

May I have an example of using UserState Parameter in the Api.Data.Calculate? Thank you  

Hi Everyone, We recently migrated from 7.1.3 to 8.4 . after migrations, we are facing issue in Calcstatus- Consolidation from Bottom to Top ( Parent).   we tried to consolidated-calcstatus from beginning of the data to till now. But its not running properly or not showing value in parent level. after closing cubeview again its showing CN. is there anyone faced this issue and find the solutions?     

Hi All, I am designing a new app with huge data set at detailed level and need time at weeks level. I would like to know if going by custom profile with time dimension at weeks level would be more efficient or having time dimension at month level and using WEEKS in User defined dimension would be better in the performance. It would be great if you can share some pros and cons for both the approaches and which one would be optimistic. Thanks in advance.   

From a button-click, I want to open a different Dashboard, in a new tab (or just open it). It should be fairly straight forward, using: But if the Dashboard I want to open is not within the "Default" workspace, OR, if the Workspace that is hosting the Dashboard is not set to: the function does not work. Smart as I am, it should only be a matter of minutes to figure out the right combination, hereby prefixing the dashboard name with the Workspace name: XFPage=Dashboard:Current.MyDashboardName. But nope. Hopefully someone out there have the right combination to unlock level 2 to the Dashboarding Tour de Master. Cheers Frank

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!

Hello, colleagues, Could you please advise am I right that when I create new user in OneStream application (and indicate his e-mail address in user profile), this user will not receive automatic e-mail notification about this?  

how can i retrieve Entity, description, currency, IsIC and few text fields in Cube view like in Grid view for entity dimension?

There are data management tasks scheduled, they are designed to extract OneStream data and load to external database. Some failed with below error messages, but they succeeded later on. Just wondering what could be the possible causes, I would appreciate if anyone could help me understand                

Hello, everyone, I created book in OneStream, which includes several cube views, and open this book in Excel OneStream Add-in. Could you please advise can I change some parameters in this book, for example Time member, and refresh all cube views in this book in order to received updated figures based on new parameter? Or it's not possible, because books which I open in Excel OneStream Add-in, contains only values and if I want to update reports via Excel OneStream Add-in I need to create quick views in Excel OneStream Add-in?  

It does not appear that Cube View Extender Rules can be applied to Excel output. Can someone confirm this or provide an example if you have gotten this to work? Thanks!

Can someone please explain the difference between "Apply Access" and "Increase/Decrease Access" in Slice Security ?For Example : How it makes a difference when selecting "Apply Access - All Access" Vs "Increase Access -  All Access"Also please advise any training materials for Slice Security? 

Hello, everyone, Could you please advise is it possible to see workflow status on each entity (if data was loaded or not, if there are any validation issues etc) in one report?  

Hello, everyone, Could you please advise if we will need for Budget scenario more detailed accounts, than for Actual scenario, am I right that it will be solved by the following way:     Create second Accounts dimension     Apply this new Account dimension to Budget scenario on tab Cube Dimensions in Cube Could you please also advise how to copy existing Account dimension members into new Account dimension (as the first step before members updating for Budget scenario)?  

Hi AllWe are using 8.4 at our new client and have been tasked with creating dashboards suitable to view on a tablet, web, windows app and phone.We have created different dashboards for each of the different devices, i.e. tablet, phone, windows app and web but have noted that for example, the phone dashboard formatting shows differently on each phone, depending on the phone screen size and it does not auto adjust to fit the screen size of every phone.Same as for tablet, web and windowsApp. Where can I get settings for auto fit on each device so that it shows uniformly on each device regardless of screen size? 

Dear User Community: My users have asked me what is the major difference between version 8.4 and soon to be released 8.5. Does anyone have an answer?  Has anyone been part of the beta groups (guessing they have them)? Love to hear because we need to know if we should wait for 8.5. Thanks,SP

Hi there,I'm looking to automate dimension uploads in that I want the dimension to be "replaced" with the new one that I am loading. I want to reduce the burden of having to add or remove members from dimension and just automate that process. How can this be done and where should I start? Thank you in advance, Joesef

Hi allI have a tableview that retrieves cube data and adds the stage data for the cube data. It is displayed in a spreadsheet which has conditional formatting to highlight the stage records. My problem is that all the formatting is wiped when the tableview is executed. I have tried to format the rows in the tableview but the only option I can find is for column format.Does anyone know if it is possible to retain the formatting in a spreadsheet when using tableviews. Failing that anyone know how to format the rows in a tableview (I want to format some not all rows).Any suggestions appreciated. Thanks Marcus

Hi, I am unable to access external database view via sql table editor in the Cloud OneStream (version 8.2). Can somebody suggest what can be the possible issues? It is working fine when accessing the current app database but only issue is when accessing external database. The external connections are fine as able to access the data via data adapters.

Hi everyone, Does anybody knows how to replicate the SEC format in a OneStream cubeview?  Here an example from Facebook.   Sincerely,  

I have 1200+ orphaned members with no data in my U6 custom dimension that I'd like to delete.   The delete icon only allows 1 delete at a time.  Is there a way to perform a mass delete?

Hi All, I am trying to schedule a task in Task Scheduler to trigger a Data Management job every 180 minutes, starting at 02:50:00 AM and ending at 9:00 PM. However, when I attempt to set this up, I receive the following message. Is this a warning, or is it something that needs to be addressed in order to resolve the issue? Thank you for your assistance.  

HiI appear to be having a slight issue when trying to feed the user selection of multi combo boxes embedded in the main dashboard to other dashboards that the user would be navigating to (i.e. their selection on the main dashboard would be the default in the next dashboard).  I can currently only get it to work for one single combo box at a time?I'm using a Dashboard Extender Rule which incorporates both the LoadDashboard function type (this is activated against a server task for the dashboard being navigated to) and the ComponentSelectionChanged function type (this is attached to each of the combo boxes as a changed server task)Any advice on this would be much appreciated or if there is a easier way to achieve it?ThanksAndy 

The Preserve Excel Format option seems to work for retaining formatting done in Excel when re-opening and refreshing cube views. However, I'm finding that my data is greyed out as if invalidated upon refreshing a cube-view in Excel after the initial connection. I've tried setting the font color to black and that was overridden upon refreshing as well, even though all other formatting is still intact. Perhaps there is a setting I am missing?

Good Afternoon,    I am trying to save an offline file in onstream retrieve and I am getting this error. Not enough memory resources are available to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY)) Has anyone had this issue

Hello,We've recently upgraded to OFC 8.4 and after this upgrade, underlying RCM table names have been updated.For ex - XFW_RCM_ReconItems is now updated as ReconItem.Earlier on OFC 8.2 , we were able to query this table using a data adapter as well as in Business rule (DBConnInfoApp) . But now it's not working anymore. Same issue is occurring for all other RCM related tables. It does work for other tables not related to OFC/RCM (for ex - Member).Are there any restrictions in OneStream to query certain application tables? Is there any workaround for this?Regards,GauravTable showing in Application Database: Giving error while querying from data adapter: