Reporting

Each member from entities hierachy has a value for Text1 member.   In the report, I use this member to get the columns needed. It looks like this    Is there a way to make that Text1 (SSC) into an aggregator, from wich I could expand, or collapse, the columns, like a tree?

Hello ! I'm facing an issue where I want to change the value in one of the cell of an SQL table editor. The row is already there (generated via business rule), but I just want to edit a cell of this row. When I hit save, I get the message "Database update error. The wrong number of database rows were processed". It only happens with this row that has been inserted by a business rule. I am able to change the value of all rows except this one. Also, I don't have any business rule running when I save my datatable. Strangely, I get the same error message if I try to delete the row ...   How to solve this situation ?   Regards,

When I export the cube view to Excel, I want to format the header of the report by moving the title to the left, removing any empty rows between the title and the subtitles, and making the subtitles bold. Is this possible without altering the rest of the report's format? If so, how?

Hi All, We have an application implemented with horizontal extensibility. We are trying to implement vertical extensibility now. We are leveraging all the dimensions we have used in horizontal extensibility except we have created new entity and account dimension along with the new cubes.  We are using the same flow dimension and same members of rollforwards and cash flow. We have uploaded the data successfully and got the TB but when we are trying to implement cash flow then we are having below error.   I checked all the code. This code works for my other cube which is using totally separated dimension and also separate flow dimension having separate members for rollforwards and cash flow. My question is can we use same flow dimension, rollforwards and cash flow member for different cube if we are already using those for one of the cube to get the cash flow statement done? I am pasting the code below for your reference. This is the exact code which is working perfectly for h

Hello Experts i'm trying to create a report to calculate fcst numbers based on driver.  for driver, i'm using dynamic calc where i'm taking 3 month moving avg as %. my user wants the ability to tweak %. how can i do that? if i add an additional column and ask my user to just enter change in %, i can add both columns using cvc. but the accounts in my rows are parent members. i cant save data at parent and i do not want to use text properties for accounts.

Hi, I created PowerPoint deck for reporting in the OS Book where I  attached few cubeviews, But when i try to view the report it shows what ever fits in the one page but if the data is more to show extended rows that just cuts off and not even moving to next page. Can someone point me out what i have to do so i can pull the full data which i can see in cubeview in Power point extended doc reports.  

Hello!! I am trying to parameterize all the dimensions within a business rule. I am doing this because I want to use that business rule in the cell format of a cube view to make it dynamic. If passing the rule parameters within the cell format of the cube view works, I will include an image: However, when passing the parameter in the cell format of the business rule, the statement is not working: The parameter is created as a literal value type. Could it be that it's not working because of the |CV|? Attached is an image of the parameter. I hope someone knows how to solve this. Thank you in advance :))    

Hi,  I would like to perform a financial calculation based on the current and previous quarter values, then returns the result. I have created the following layout of the cube view. I would like to do calculations such as ( previous Q amount + Current quarter account ) *2 for an account  should be the value of the row 2. However, I am unable to achieve this because , I would like to do this for all the Q columns and then the POV changes. for example. Q3 calculations would be ( Q3 actuals + Q2 ( prior q) actuals ) *2 and similarly the change would be observed in Q3 results. Get Data Cell is not possible I assume here because of dynamic column usage. Is there any other simpler way other than the use of XFBR?

Upon logging into the OS for the first time, the initial file refresh takes a long time, but subsequent refreshes tend to be quicker. Do you know what causes the first refresh after logging in to take so long?

Hello everyone!I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow.I’m using the XFSetFxRate formula, and it works when I hard code the time, for example ‘2020M1’. However, I need the time to be dynamic, to change based on the workflow.Is there a way to bring the Workflow time in the XFSetFxRate formula? I tried WF and WFTime, but it doesn’t work.Thanks!

Hello All,  Is there a way to automate Security Audit Reports?  I'm currently running ad hoc user reports for Audit and would like them to run on a schedule.  Thanks!  Cheryl Patterson  

Hello, I have created a button that opens a Book from File Explorer. This particular book requires prompts to run correctly, but when running the Book from the button, it skips the prompt dialog and runs with errors. Is there a way to have the button ask for the prompts before running the book? Thanks!

Has anyone had any issues Windows 11 and QuickViews? We have one individual only that cannot seem to run QVs, or if he can, it takes several minutes to do so. Any ideas what it could be that is causing this? We are on an old version of OS. We changed some preferences in the QV and that helped. We have had IT look at his setup and they found nothing out of the ordinary. We are at a total loss as to why one individual is having problems out of 50 + users. Any ideas will help. Thanks

Hi Community,             I have a Cube View which has multiple source rows and a total row at the very end which is using GetDataCell(CVR()) to obtain the Total.Is there any way in which I can hide the source rows and just display only the Total row. Thanks,

I am writing the Business rule in Revenue % account dimension,  Revenue % = X / PY Y. My PY can be based on POV. For example, if user can select current year as FY2024 then PY is FY2023 or If user choose MAY 2024, then PY is MAY 2023 or if user choose Q2 2024 then the PY is Q2 2023.  I am using this code and I am able to achieve if it is year, but I need more of dynamic based on user selected PoV. how to automate this code based on PoV. any suggestions would be really appreciated. Return api.Data.GetDataCell("-A#X / (A#Y:T#GlobalPrior1")

Hi, I am getting error when retrieving parent member name of a UD dimension using XFGetRelationshipProperty. I have used below syntax. Could someone please help me. XFGetRelationshipProperty(“UD4”,B15,“ParentMemberName”,"","","")  It returns #ERROR: PropertyName      

I am using OneStream dashboards and have set up a pivot grid. On desktop, I have configured a default layout for the pivot grid, which works as expected. However, when I access the same dashboard through the browser UX, the default layout does not apply. I have tried clearing the browser cache, but the issue persists. Has anyone encountered this issue before, or can provide insights into why the default layout is not being applied in the browser UX?  Additionally, on Desktop, the pivot gris appears in classic format. On UX, it comes as a hierarchy. Can we default to use classic format on browser UX?   On Desktop: On Browser UX:

Hello, We have a cube view with a couple hundred rows, when in the designer view it is hard to find the row we want to edit since it reads the row number vs member info. I know it's possible to update the name but that would be tedious to do one by one. Is there a setting or rule that would override the row name to equal the member number/name/description? For example "Row192" would read "LE30102" or the actual description.  Thank you in advance! Rana

Originally posted by Natalie HagerlidIs there an excel-add in that works with MAC?

Dear Community, Is there any possibility to get column names using Cube View Extender rule or XFBR? Thanks in advance. 

Hi there, we are trying to figure out a way of collecting capex project information in OS inside a user friendly form (not capital planning register). Wonder if anyone else is doing it and how you are accomplishing this? Trying to figure out how to allow users to enter project number and name without creating metadata for each project in one of the dimensions ahead of time or if there is an easy way to accomplish this. The information we need to collect is really minimal, number, name, description, amount per year and a classification in one of three buckets.

I have a dashboard report with text boxes that grow with the text.  Is there a way to prevent the box from breaking on a page break?  I know how to do this in Word, but cannot find a setting for it here.  See screenshot for example.  Apologies, I had to blur the actual text.  

I have attached the Parameter (Delimited) in the Cubeview. In parameter I have added a drop down what that drop will do it will add 2 flow dimensions members data which is huge. for 2 column data adding it will works fine but when I run it for whole entity.base or account.base, after few minutes OneStream forcibly stop process. how can I solve this problem ?

Hello, I was wondering if there's a way to use one of the OneStream Excel functions (i.e. =xfgetmemberinfo) to grab data from a Cube View Connection? I know I could pull this data from the headers, but my work doesn't like using them really and was wondering if there was another way. Thanks, Will

Hi, Does anyone know a report that shows all workflow profiles and who processed them? I know that for forms we can use adapter - FormsStatusForWorkflowUnit, but it's just a forms - I need all inputs. Many thanks!