Reporting

For planning.Filling data in on quarters spreads the data out to the monthly columns.We do not want to see the monthly columns anymore. When set isColumnVisible = False you are not allowed to enter data on quarters, it becomes a no input. Is there a bypass, so we are able to enter data on those quarters?

Hi, We have a cube view with 4 levels of Row expansions UD1, UD2, UD3 and UD4 (Currency). We need to add 2 more levels for UD5 and UD6. Is there any way we can have 6 levels of Row expansions in Cube View? Thanks & Regards, Madesh K

Hello All,   I am working on a dynamic calc in the account dimension to calculate percent margin. If the percent margin shows above 100% or below -100%, I want the cube view cell to display 'NMF'. At the moment I believe I have the syntax correct in my formula, but maybe my execution isn't right on. My suspicion is that I can't return strings for the CreateDataCellObject. Full formula below:   Any help is much appreciated!   Dim PM As DecimalPM = CDec(api.Data.GetDataCell("Divide(A#PRODUCT_MARGIN,A#PRODUCT_REVENUE)").CellAmount) If PM > 100 ThenReturn api.Data.CreateDataCellObject("NMF", False, False)Else If PM < -100 ThenReturn api.Data.CreateDataCellObject("NMF", False, False)ElseReturn api.Data.GetDataCell("Divide(A#PRODUCT_MARGIN,A#PRODUCT_REVENUE)")End If  

Hello community, We have build a custom dashboard, within there is a circle graphic and several lines with the users info. When trying to export to PDF only downloads X number of lines, but not all the lines that are close to 450. Instead, when downloading using the export to excel it does export all the lines. Any thoughts? Do I have to configure something in order the PDF export all the information within the dashboard? Many thanks in advance, Arion

For planning I have 3 rows with the same account Origin; Beforeadj (Aggregation) Import (Shows seeded actuals) Forms (Input) Scenario's in the columns and a separate column we have comments. (Annotation) We overwrite the Import and Beforeadj with forms. Means it will show 3x times the same text in the row. Anybody knows how to bypass the origin behavior? We basically want to post on all the 3 rows separate comments.

Hi all, Currently we are trying to automate some offline reporting processes via excel macro enabled workbook (.xlsm). Basically these files contain both XFGetCell and regular excel formulas and then there is a macro in place which combines the numbers from all different tabs into one, removes all unnecessary lines and then generates a OneStream load file.  These excel files are very large in size and they take forever to refresh from the desktop. The same files are refreshing much faster if we run them directly into OneStream Spreadsheet (Application>>Spreadsheet). So no issue with the refresh within OneStream application but as soon as I save the *.xlsm file within OneStream, the file got corrupted, and I'm not able to open the same file again from my desktop. See the error screenshot below. Has anyone seen this issue before and know how to fix it? Please let us know if you know the answer.  Thank you in advance!!!   Shetal Patel Shetal.Patel@xylem.com OneStream

HI   I have been asked by our Finance team to build a report that summarises intercompany variances to speed up the hunt for mismatches. We use the current out of the box interco reports but they want something quicker and easier to use. Just wondered if anyone else has used/built something similar ? Thanks Tahir

Sharing rows and columns allows users to copy rows/columns between Cube Views. Question Credit: Becca Speese 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

Hi, in reference to the code sample below.  Is it possible to visualize the consolidated comments on separate lines in a cube view?  They start running together and get hard to read.  I tried inserting Environment.NewLine or {vbNewLine} into the code but that did not seem to work.  Any suggestions? Finance Dynamic Calc: Annotations Consolidations thanks, Greg

Hi all, Does anyone know how to easily overview changes in the EntityDim in terms of Percent Consolidation and Percent Owenership between periods and years? Can this be extracted in a prebuilt report or built in a cube view? For example if I would like to get a snapshot of one hiearchy in the EntityDim including percent ownership and percent consolidaiton for period 2020M10? Thanks, Fredrik

Hi, I have created a dashboard which contains multiple BI viewer components. Each BI viewer component is composed of a data grid and a set of list box filters. Is it possible to setup the BI views so that the selection done on the filters by a user is retained when switching to a different BI view within the same dashboard.If an user select the Cost center "0002 Internal Audit" in the first BI view, and the same user then select the second BI view, the selection on the Cost center filter (which is available on both BI views) is not retained and the filter defaults back to "Select All". Is there a way to change this behavior? Is there something I should have setup to have the filter shared between the multiple BI views?Thank you

We recently upgraded from 6.8.1 to 7.1.3 and I have about 5 users who are having issue with Excel add-in.All of them are getting below error once they login. I tried disabling all other add-in etc but it’s not working.Any ideas?Saurin

Hi all,  In a CubeView we want to see selling and buying members in one row. So for Column 1 is sales where the Entity is the selling entity and IC is the retrieving entity. in the same CubeView Column 2 is stock where the Entity is the Buying Entity and IC the selling entity. So for Column 1 i want to see E#Entity:I#IC and for column 2 E#IC:I#Entity. This is straightforward in an xfGetCell in excel but then i cannot do row suppression. I haven't found a way (yet) to get the current row's Entity and populate the IC dimension with that value using e.g. an xfbr rule.   Thanks in advance,  Marc

Hi,I'm trying to create a dynamic calc script that will increase this column's value by 1 for each member in the adjacent column. For some reason, my script is not doing it instead it is returning the same number 2, Would you guys be able to assist with this?  I'm trying to do it in a cube View. Thanks. In reality, I just need to increase each row number by 1 and I believe it may be possible. Ideally, I want it to be a Dynamic Calc over an XFBR. Has anyone done this before? Can it be done in the UD8 Dimension?

Question on how to loop UD#1 children using the member filter type, UD#1 loop definition and a POV parameter. I get only the first child’s data on all of the multiple pages. If I same my select department I am able to see the different pages but no data is coming into the Cube View. Posted by Carol Vredeveld Migrated from Champions

Hi All, We are exploring an option to extract the system log from System database table. Table names are “TaskActivity” and “UserLogOnActivity”. If any one of you can guide me, what would be the best way to achieve it. Thanks & RegardsMayank Posted by Mayanka Bhusan Migrated from Champions

I am testing an update from version 5.1 to 6.4. In our current version, when I select a workflow form that opens an Excel file with an embedded Cube View, the form opens with the Excel menu set to “OneStream XF”. This was good because the user can input data and hit the Submit Sheet button with a single click. Now in version 6.4. the form opens and the default menu item is “File”. Requiring the user to first change the menu to submit data. Is there a way to set which menu item opens by default? Thank you…Bill Posted by Bill Walke Migrated from Champions

When building CubeViews there is the .remove string that you can use to exclude a member from a hierarchy that you are pulling. Is there a way to replicate this with =XFGetCell formulas? Or in general, a way to include more than one member in an XFGetCell formula? Posted by Dylan Cox Migrated from Champions

Hello Friends,does anyone enabled paging controls on Cube Views?that will be a nice feature to use when we have more number of rows.  Capture.PNG.jpg3288×1118 310 KB got this info from release note.Under the theme of Performance and Scalability , we have continued to enable faster performance on large data sets by allowing users to manage paging controls on Cube Views and by enabling Sparse Data Suppression on Excel Quick Views. This feature increases performance for ad-hoc analysis on large data sets within Excel Quick Views.ThnxKP Migrated from ChampionsPosted by Khirod PAlai

Hello All, Administrator of the application we are working on wants to allow users to do some analysis on their budget data at detailed level, crossing 3 dimensions in rows (the same way they are doing in SAP currently) which are quite big (entities, cost centers and accounts). I proposed him to have users using quick view to analyze but he estimates that users will not be able to use this and wants that they use rather objects that are kind of pre built. Then I thought of either cube view or BI Viewer (with CV MD as source) as they want to have totals in the retrieve corresponding to the parents of the dimensions but then either potential number of intersections are too big and do not allow to render the CV or performance is not good. So wanted to reach out here to see what could be the options to answer above needs (give user a nice to use place to drill in those 3 dimensions to analyze his data while still having totals for the parents of those 3 dimensions) ? Thanks for your help M

Is there an easy way to retrieve the subtotal of all the values returned in a Cube View expansion? For instance, we might have on one Cube View Row with a nested expansion such as: E#Company1, E#Company2, E#Company3 A#Account1, A#Account2, A#Account3 What I would like is to be able to add another row to my Cube View that is the sum of everything that retrieved in that first row expansion (could have returned anything from 0 to 9 rows of data).  Today we do a klunky solution, such as : GetDataCell(CVR(Row1,0) + CVR(Row1,1) + CVR(Row1, 2) + ......), which unfortunately is not dynamic.

I have this cube view that I'm building to mimic a report that I'm doing. Each row of this cube view uses an aspect of the UD-1 base member. Such as PE, Description, Name etc. How do I get my cube view to populate different elements of the same user dimension on each row? The picture below gives an example.   

Hi all, I am wondering if there is a way to make cube view available outside the WF. I have developed many forms for the workflow filling all the cube views with WF, WF.... Now I would like to make these views available outside the workflow, where the period, for example is, selectable from the POV. Do I need to duplicate each form and then remove the WF on scenario, period and entity? Or is there a smarter way to make the view recognized that the is opened outside the workflow?   Thanks in advance for the help. Marcello      

We have fields defined in our connector that are not mapped to a dimension or attribute. I need to build a data adapter to take data from StageSourceData and tie it to the table that holds the data brought in by the adapter so I can grab one of these fields that is not mapped (Location). Can someone advise what is the table name that holds the raw data brought into OneStream by the adaptor (before it is mapped to a dimension or field)? Thanks!

I have a reporting requirement.Projects rollup into customers in UD1.  UD6 contains employees.Reporting requirement is to display both customers and projects U1#Total_Customers.DescendantsInclusive. Also  display employee U6#Total_Employees & U6#Total_Employees.Descendants .  This issue is when the report renders they only want to see Total_Employees (UD6) at the customer level and  Total_Employees.DescendantsInclusive at the project level.   example:--UD1-- --UD6----------- AmtCust1  Total Employees 250  Proj1  Total Employees 100            Dave                     50           Scott                      50 Proj2 Total Employee   150          Mike                      &n