Reporting

Hello team, I am trying to get a dump of Yearly data in one table where I will use joins of member table with data records and want to expose this in BI viewer so that analysis can be nicely done on Month on Month, YOY basis etc. however pulling so much data seems problematic and I came to know about a term 'FDX' (Seems Fast data Extraction). Kindly help with some details on it, I could not find any content on this.   Thanks Satish

We have a requirement of replacing Power BI dashboard's with OneStream .Which module would be better apt to configure from marketplace to full fill this requirement.

Team Is there a way where i can sum the columns/data using Variables.  Example: Instead of using GetDataCell(T#2021M1+T#2021M2):Name(Total) , can i use some kind of variable which calculates based on POV/Cube view GetDataCell(T#Quarters):Name(Total)  

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? 

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

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?

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!

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.  

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

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  

This is my first time creating a book. I'm working on creating a book that presents an income statement by location. The ideal outcome is that the IS is displaying location at the top and each subsequent page displays a child location member.  I have my loop setup as a member filter that references the location dimension as shown below. My change parameter is setup to change the POV.  When I preview the book it's still showing location at TOP for all the pages instead of showing TOP and then each location base member. Any suggestions on how to fix this or any literature would be appreciated.   Thanks.

Hi Community ! Is there a way to get the culture of the user, by using a retrieve function like XFGetCell? Basically, I have to retrieve the user culture in an Excel file in order to define Titles and other periferical elements in the spreadsheet. Regards,

how can i get 2 columns on a quick view to be shown as %? 

Please see this post from Adam. Posting on his behalf. I also want to know the answer to this.