Reporting

Conditional Formatting determines if you want to display gridlines within Excel. 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, 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

Hi,  In a forecast scenario I have placed some text in the "Custom settings" Text 1 What it the syntax to get this text1 into my header of the CV? T#Year(|WFYearNext1|)Q1:S#WF:name(|Text1|)

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

Hello, I am trying to write a rule where I get the base of Net Income where the Text 2 field is not blank. Does anyone know the syntax to indicate blank?  A#NET_INCOME.Base.Where(Text2 <> ????)   Thanks!

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, I'm trying to build a cube view having a list of Entities on the rows. I'd like the row label to be the entity description followed by the entity currency. I was trying to use the Name function to do that. I am able to display the entity currency like this for example: E#Tot_Entity.TreeDescendantsInclusive:Name(XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency)) Similarly I can use the XFmemberproperty function to retrieve the member description, like this: E#Tot_Entity.TreeDescendantsInclusive:Name(XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Description))   However, I have been unable to combine the 2 things. How do I concatenate strings within the Name function? Thank you

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?

Hello,   As my title indicates, I am trying to create comment columns within my CV's that utilize the V#Annotation and V#VarianceExplanation members and am stuck at a roadblock with this error: Error saving data attachment. The intersection is read-only. Is this something handled within security? Any help is appreciated.   EDIT: I have heard that one possibility is that this is not a base level member that I want to make a comment to. Could that be the reason why? And if that is the case, is there a way to get around this?

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.