Reporting

Hey Experts, I am trying to read the Datacelldetail line items. thought of using Method query but not able to filter it based on UD filter criteris. does anyone know if it is possible? whats the systax to make it work. In below example I am trying to filter and get all the rows for UD1 DL014. when I run the query it gives me erything for that Entity,Scenario and Time. Appreciate the help.    

Which CV format section or POV setting will allow me display account number and account description together?  Currently only the account description is being displayed.   Need to see: 10000 - Cash Current settings: Cash   Thank you,

Hi All, I am facing an interesting issue (or a bug). Requirement: Capturing comments using a text box (linked with a literal parameter) and save it as annotation text so that it can be pulled in CV reports as well.  Using literal parameter as I set it to stored comment using the BR when click on a cell in CV. I have a save button to save the comment if they want to change it and save it. when they save reading this text input in the textbox. so same textbox is used to display and write. I am passing this text as [|!Param!|] to rule. whole setup work great but found an issue when there is a unbalanced "[" or "]" then it throws this error.  Error: Invalid comma separated values. Unmatched brackets wondering if anyone seen this or have a workaround to handle this? appreciate any help.    

Hi All- Can someone share how to hide the Instructions dashboard and show the TieOut Report dashboard when the Run Report button is pressed?  

Does anyone know the order that XFSetCells load in a spreadsheet?  I have duplicate metadata key infomation, and I'm trying to handle it by doing some accumulating with some more generic formulas.  I assumed it loaded top down, so the lower cell would be the last value loaded to overwrite preceding ones.  Doesn't seem to be playing out in every case that it's submitting top to bottom.

I want to be able to drill to HR details in BIBlend from any users cube view, so I set up a linked Dashboard using Default NavLink parameters, and a SQL data adapter using these default parameters.  It is working perfectly except for Account.  The cube account mapping logic is concatenating 3 columns in the detail file to map to a headcount account (ex Full-Time - Exempt -  Associate).  I assume I will need to set up separate BRs to apply this logic.  I am wondering if there is a better way to do this?  

I have a cube view that I need to modify so that in the second column we are getting data that is driven by the selection that the user makes for the first column. For example if the user selects a forecast for February to be in the first column, then the second column of the cube view would have to be the previous month’s forecast. Do you have any suggestions on how to achieve this view? Thank you in advance for any help and suggestions! I am going to attach some views of what I have in here so far (The second column reads OP plan as I have copied this view from another similar Cube View).          

Hello,I hope you're all doing well, this is my first time posting in the forum.I recently built a cubeview that contains one Row, I was wondering if there is a way to automatically generate blanks after each member - in my case after each Entity of the hierarchy - and considering that i have multiple member expansions.In order to clarify my request, please find below an overall of how do blanks should be automatically generated (1st Screenshot), you will also find a screenshot of the members used in my cubeview.Thanks in advance, wishing you all a blessed day

In looking at the dashboards page, the first item that needs to be created is the dashboard maintenance unit. Question Credit: Andrea Tout 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 all, This one is a bit of a doozy, so bear with me. In this specific instance of an application, we have multiple cubes that share identical hierarchies, except one cube uses the Entity dimension, and one uses the UD2 dimension. Ex. below: Cube 1 = E#10001 Cube 2 = U2#10001 Our goal is to have a cube view that compares the actuals from Cube 1 to the Forecast of Cube 2. We have tried many ways to work around this, resulting in our most recent endeavor of using UD8 dynamic calculations to return a data cell value from a member script in Cube 2. Our issue is that while the UD8 shows the proper data, it does not allow end users to properly drill down from the data cell. It also does not allow a user to see the proper cell POV of the data being presented. Is there a better approach to this? Essentially, the goal is to have the row dynamically switch between the dimensions, UD2 and Entity, based on each column. Other constraints to note are that this cube view needs to be created using

Hi all, I am working with navigation links in my cube view. However, when I open the 'linked cube view' through my 'main cube view,' I get the member filter to show in the title of the dialogue box that opened. These are the bound parameters that I used in the 'main cube view.' Is there a way to remove the member filter from the title bar in the dialogue box? I've included below what I mean with the title bar and my issue.  I appreciate any help you can provide. Kind regards, Floris van der Poel

When a translation or a consolidation is run, the AdjInput entries are rolled into the AdjConsolidated member. This rollup occurs as the data is moved along the Consolidation Dimension. Question Credit: Peter Fugere 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

Happy New Year Everyone! I am hoping someone has an example of how to use the formatting rule in OneStream Dashboard Reporting to change the style of any row in table oContent where label13 (field OFCvRAVAR in my dataset) is not zero. I think it's also possible via a script ... Have been looking in Golfstream for an example, but no luck. Thanks!

I can drill from the Journal report Question Credit: Peter Fugere 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

Is there an easy way to traverse with in a cube view like ctrl home, ctrl end, ctrl + up arrow, ctrl + down arrow in a Data explorer view. Need help.

Hi guys! I would like some guidance on how to pull all children at the same level in a Quickview. Thank you.  Oliveira, Vanessa

You cannot use OneStream to directly report on SAP data Question Credit: Jack Lacava 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 community, refering to the solved request in the link: Solved: Show 0.0 in Cube View Data Cell instead of blank cell - OneStream Community (onestreamsoftware.com) Is it also possible to get a drill down here? That doesn´t work with the described UD8 anymore. Thanks.

In a cube view, how can I use a manual input value in the formula in another column? Col1 Col2 Col3 EndBal Input Value EndBal - InputValue Many thanks in advance. Winni

All calculations must be executed as part of consolidation activities (Calculate, Translate, Consolidate). Question Credit: Jack Lacava 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

I am looking for a Business rule function to write "data unit statistics" filtering on Year,month &Scenario. (OR) Cube view which can display DUS on the report.   PS- I know we can right click on calcstatus to get the DUS but require something which can create a report/write to a table for DUS>      

Hello - we are running the intercompany matching report in the Application Reports dashboard and I see there is a setting which states "Suppress Matches" is set to false as a default. Please can anyone advise how to change this to true so we just see the mismatches?   Thank you!

Hi all, We have a question about invalid intersections in reports and whether it is just a presentation issue or if we need to be worried about calculations or transformation rules as well. We have Cost Centers in our UD1 dimension and we have some Accounts that require specific UD1s. For instance, Account 62000 Gross Sales has a constraint of UD1 65000_F Sales. The event handler ensures this combination is maintained when loading data using transformation rules. For reporting purposes, we have now created an alternate UD1 structure that does not include all UD1s for some very specific reasons. Now, when running reports such as the P&L, the row for Gross Sales shows pink when the alternate UD1 structure is used because that alternate structure does not include UD1 65000_F. The displayed data is still the correct Account 62000 and UD1 65000_F combination, but the cells are pink since that UD1 of 65000_F isn't in the alternate UD1 structure. This alternate UD1 structure is only used

There are 2 Column Overrides that can be applied on a Row. 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

  The Member Filter Builder provides examples of calculations 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