Reporting

When I run a OneStream book, the time zone in the footer is in UTC, which is 5 hours different from my time zone CST.   However, if I run the individual cube views that are included in that book, the time zone is converted from UTC to CST.  How do I get my books to properly reflect the CST time zone in the footer of each page?  Book in UTC time Ran cube view from book afterward and it is in correct CST time Thanks!  

Hi Team, We have client requirement that, Member needs to be moved from one parent to other parent. In this process, it should not impact rollup data for old parent for historical months. If any handle this in the past, please share your thoughts on this or any inputs would be appreciated. Thank you.  

Hi there - Im looking to add a formula to my columns located in the cube view. I need it to pull global time + remaining target months. This involves two scenarios, so S#Actual and S#Target_FY24.    So If my POV global time is July, I need the formula to take (7 months of actuals using S#Actual) + (5 remaining months of target using S#target_FY24). I also need it to be dynamic so I dont have to touch each month, so when the POV gets switched to August, it would be (8 months of actuals + 4 months of target)

Hi all,  We are building cube views which require the expansion of three dimensions in the rows.  We use the "Allow Insert Suppressed Member" function to insert suppressed members in two dimensions. Since the expansion would generate a very long list of combinations, we want to use the function "Allow Sparse Row Suppression" to improve the cube view performance. But when a period doesn't contain any data, the allow sparse row suppression function would suppress all the rows, and we won't be able to insert suppressed members.  In the cube view rows, we have the suppression setting as in below. Can anyone give us some advice on how we can tackle this? Thanks in advance!

In Application tab > Dimensions > Entity Dimensions > Member Properties, I have something configured in Text 4 and Text 5  field in Vary By Scenario Type And Time section. The goal is to display these 2 field values in a dashboard.   Questions are 1. How can I retrieve the data in SQL in data adapter? I input test data in Text 4 and find the value in both RelationshipProperty and MemberProperty tables. Which table and column should I use? What filters are needed to get the expected value? 2. Any data dictionary for OneStream application database? For this type of requirement, use SQL and data adapter to get the value for specific fields in the front end, how can I find the respective table / column / filter. Much Appreciated!      

If these are my parameters: (delimited list and input value) what would my columns be? This is ultimately what the report should look like:  

Hi, I'm wondering if anyone else has had a similar issue when creating DynamicCalc accounts that include a non-financial account member and a financial account member? I'm trying to create a revenue per day account that will use our A#SalesTot account and our A#IscSalDays account.  My formula is below: Return api.Data.GetDataCell("Divide(A#SALESTOT, E#DRIVER:C#Local:S#Plan:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#Top_UD2)") When I populate a cube view with each of these accounts separately, I get the correct data, but I can't figure out why the calculated account returns blank green cells.  Since I want to use the result in a dashboard chart, I can't use a column row math expression, which is how I calculate revenue per day in our other reports.

Hi All -  I am wondering if anyone can point me in the right direction on how to reference a business rule to generate the SQL statement within a data adapter for SQL / External type data adapter? Any help would be greatly appreciated!

HI Can someone help on connecting a Dashboard report into Books, am trying to connect it to Books and then use the parcel service to publish the report to distribution list via email Regards Nara2757

It would be helpful if there was a way to toggle the "Include Cell Attachment Status" setting for Cube View Connections rendered in the Spreadsheet tool. 

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?

Hi all, I am building a CV that needs to show quarter data starting from Q1 2022 with YTD data after Q4 of each year and wanted to build it as dynamic as possible. I am trying to avoid having to update the filters each quarter if hardcoded. I also have a parameter that prompts selection of a specific Quarter/Year. The layout should look like the below. Is there a way to do this dynamically? I am also coming across an issue when calculating the growth % on rows where there is no data. It is giving an incorrect growth % of -100%. I have tried conditional formatting to try to hide these incorrect % but can't seem to get it to work and wondering if there is a better way. Thanks in advance for any help!

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?

Hi, How can we ensure that a record is only saved in the SQL table editor or grid view after all cells are filled? A message should be displayed to the user if any data cell is left blank when attempting to save. Is this functionality available in version 7.4? Thanks

Anyone know what report or how to implement this? I have seen this role in application security role but cant seem to find on what it really does. Says its gives a user access to a report in import workflow...Thanks!

Hi, I have an SQL data adapter that queries an application table, and one of the columns is the CostCenter. This CostCenter is also a dimension in our cube, where the table values correspond to the base-level members of that dimension. In the CostCenter dimension hierarchy, each cost center is either a descendant of Member A or Member B. I want to add a column to the data adapter that indicates whether each cost center is a descendant of Member A or Member B, so that users can filter cost centers more easily in their dashboards. Does anyone have any ideas on how I could achieve this?

hi Team; I've a cube view showing accounts than need to highligh in red when overlap a number dependig the FxRate, I created an Finance BRule searching for a specific rate and multiply be a number where is more than this is highlighted in red. My problem is that number is recorded in a paramenter but is not working, maybe in the image below is showing better than my explanation; could sombody knows how is the parameter format? Thank you and best Regards Mario G

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!