Reporting

Hi All, I hope you are all well!  Just a quick intro - I'm new to OS and have just completed my first training course. I work for a large global company who use OS to consolidate and report. We have an instance where we reported or Jan22 figures, but now OS is showing slightly different figures at the consolidated level. I'm hoping to find a report where I can identify if a user has either imported or updated a form for that Jan period after we reporting.  So a report that shows my by user if they entered in Jan by the stamp date?   Thanking you in advance!

SOURCE: ONESTREAM CHAMPIONS Hi All, Is there any way to see the active user count from the application? My requirement is to project the active users from the total users available in the application.

  In the BI Viewer component, is there a setting to change the minimum or maximum data points on both Y-Axis's in the top right quadrant of the print screen below?     

Hi community We are using Method Type CertificationForWorkFlowUnit in a data adapter for creating a Certification report  This Method Type provides 3 data sources (as you see in the screen): Currently, we have Profile Name, Question Name, etc in columns but all these fields are part of CertificationResults DataSource. We are trying to include UserName filed column on Certification Result Dashboard, but we can’t because this line is part of another DataSource: CertificationResult_SignOff.  Is there a way to include this Username Field? With a Join between data sources or another alternative? Thanks          

Is it possible to create a chart where one data series is displayed as a line type and the other as a bar type? 

I'm working with a BI Viewer and working out how to sort the dates within the Time data set. Is their an API that allows to call the data adapter used within a dashboard? Currently the dates on the X-Axis are disorganized and are being sorted based on M1x, M2x which causes October (M10) to precede after January (M1). 

I am creating a dashboard that compares two different scenarios (one of which is the prompted scenario). I want the header of the chart to display the description of the member instead of the name (i.e., "Forecast 3+9" instead of "FORECAST_3_9." If I input the prompt name into the description field ("|!Prompt_Scenario!|") it will return the name. Is there any way to update this to populate the description instead?

Scenario Today I have a process where I can generate a Spreadsheet with an included Tableview object, and view the spreadsheet output in a dashboard. What I want to achieve is automate the process, so I from a BR function can fully automate the process of generating the spreadsheet, and then save the spreadsheet as Excel to a specific folder, with a given naming convention. Anybody have done something like this? Thanks and Cheers  /Frank 

Hello, Within a Cube View, I would like to store some "Comments" in a dedicated Row. For display purpose, I would like to adjust the height and the width of this specific row, so it does like a kind of "text box".  I can't find anyway to adjust the height in the "Data Explorer" mode. Any tips, Cheers, Nicolas

I am trying to build a dashboard with a button that opens a scenario dimension page so that super users can easily set up and use a gaming hybrid scenarios.  Is there an XFPage option to open a dimension page?

Originally posted by Jerri McConnell3/25/2020 Somewhere along the way a while back, i was given a list of Essbase functions and their OS equivalents...I think it was something Celvin & Cameron put together when they were here...now i can't find it...does anyone have this and can forward to me?

Hello, Backstory: We have some forecast cube views we embed in our Forecast workflows. These cube views also display under the cube view folder. The cube views are set to the workflow POV and I realized this means users can open the cube view in the cube view folder and if their  POV is Actuals, they can then load to Actuals. I want to prevent this.  I updated the cube view folder security to Admins and then no one could access the forms.  Question: Is there a way to remove specific cube views from the cube views folder, but still allow users to access them in a workflow?  Regards, Ronnie

Hi, We're currently expanding on our CubeView & Dashboard reports available in the application & would like to display our performance by Country. Our cost locations are housed in UD1 with the base members being the individual cities and/or states & the immediate parents being the Country. Is there a way we can call the parents of base dimensions of the current UD1 selection? Currently we're able to build out a set structure for countries but if a user doesn't have security rights for a specific location their report will display other locations as 'No Access'. Thanks!

Originally posted by Kris Waggoner I have a cube view that has a nested dimension in the rows.  By default, the nested dimension is collapsed and the user has to expand it.  Is there a way to have the nested dimensions expanded by default?  There is a setting for this in the pivot table in BI Viewer, but I don't see how to do this in cube view

I have CV - rows with Accounts as Expansion 1 , and three Origin-member as Expansion 2. I'd like to have the Accounts as suppressed if zero ( no problem) but when I open the +-sign to see the Origin members for selected account I want all three (Forms, Adj, Import) members to show without having to use insert member. User should input data on the O#Forms member which is suppressed unless previously used.  

Statement: You can copy and paste dashboard components within a dashboard maintenance unit or to a completely different dashboard maintenance unit Question Credit: Chris Bielinski   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? We’ll be hosting a LIVE game show at SPLASH San Antonio! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

Has anyone had issues with cell reference links breaking in Input Forms after clicking Submit Sheet? Background:We plan to base level accounts, with our operating expense accounts planned between four departments in UD2. All other accounts are planned at the “None” department level. Example:611000-Base Salary account can be planned more granularly to Dept 100 (Customer Support), Dept 200 (Prod Dev), Dept 300 (S&M) and Dept 400 (G&A). A#611000:U2#Dept_100 = 5,000 A#611000:U2#Dept_200 = 2,000 In this example, we would have a total of 7,000 planned to the 611000 account. Issue:The cell links are only breaking on the 6xxxxx accounts where we are specifying UD2 as a specific department vs. all other accounts having U2#None. Additionally, the values input in the form aren’t going to the correct department. The 2,000 example above from Dept 200 would go to Dept 100 for the same 611000 account. Any advice would be greatly appreciated!

Dear Community -    Is there a way to know when the last load was completed? We have multiple cubes (account recs, mgmt, rept), and it would be helpful if our end user could know when the last  process-load was completed.  I know we have task activity manager, but if I could filter only the process load tasks, retrieve the time when data load was completed, and display in a table.  I'm wondering if I need to write a business rule, and integrate that into dashboard/cube. Any idea or examples will be appreciated. Thank you!            

Hi Everyone, We uploaded Track Record Data from 2022 January to 2028 December. But When we check data under Cubeviews- it only shows up until 2026 December. What could be the reason that the cubeview is not populated data for last 2 years. Help will be appreciated. Thanks

I am trying to troubleshoot a performance issue when running cubeviews as a non-admin.   If a user is not in the "Administrators" group, then a simple cubeview might take a lot longer than it would otherwise (by a large factor, like 3 to 5.)  Is this a known issue?  Are there any tricks to avoid the massive performance hit?

Hello, Is there a way to aggregate the result of an expansion within a member filter?  For example, I have multiple entities that are Australian.  I would like to aggregate the balances of all of those entities into a single row.  I'm using the attached syntax which produces the entire list, but I would like all the results to be aggregated into one line item without all the underlying detail.  Does anyone know of a solution? Thanks, Sean

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 frustration expressed since we switched from Hyperion to OneStream about 1.5 years ago. Here is a simple example with the Time dimension of what was frequently done with Hyperion Smart View. An Excel file has 10 tabs, one named Input.  On the Input tab the user enters a Time member in a cell.  The other nine tabs link to that Time cell.  With Smart View the user only had to change one cell no matter how many other tabs there were.  With Quick Views the user has to change the T# value in every Quick View in the file. I know this is a simple example, and if it was always for month-end, something like T#Global could be used, but they wish to be able to set the values for any number of dimensions and only have to s

Hi Fairly new to OS and i am looking for a solution/workaround on MemberName and Description in POV. To explain further, in Quick View when any dimensions is in POV (See attached Pic)  then OS only shows the MembersName not Description. I need to see Description there as my naming convention for UD is Code - Description. Having code to be viewed in POV is tough to track and know what code means.  Thanks in Advance...Sandeep S    

I am trying to build a cube view where the client can insert suppressed row members for account, ud3, and entity with ud3 having 2000+ members. I can't figure out how to work the suppression so it only shows the top row and allows the user to enter in the suppressed rows without having all combinations visible through expansion. Currently it is showing all possible combinations or no combinations. Thanks in advance for the help!

I want to add a dotted line to differentiate between scenarios. In this example - we are reporting actuals and forecast -- Any ideas?    Thank you, Mustafa