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 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 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!

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, where can I find a simple guide to formatting my reports, especially in the ‘view reports’ view? Somehow it is difficult to insert blank lines without scenarios, just formatting, do you have a suggestion here? Also the underline frame somehow doesn't work properly, I need a thicker border line but the software doesn't seem to respond when I enter a value for the thickness. Any easy solution available? Best regards, Luca

Hi I want to combine data from 2 out-of-box methods in Data Adapter for a custom grid.  Is there a function that I can use in BR to read data from the methods - FormsStatusForWorkFlowUnit and CertificationForWorkflowUnit Thank you in advance, Mikki

Is there any way we can input the data at the Parent Entity: One Possible way is Set O#AdjInput and Set Account Property > Allow Adjustments to Data Entry to which I want to input data data.But I am sceptical as it will not allow me to allow Posting a Journal on the base level entity for the account. Is there any possible or better way to do this? If I dont find an answer I have to replicate the Accounts in a alternatate hierarchy with some suffix for the with same description and then copy the data to the original account. 😞 Regards, Nikhil     

Hi, I am using word doc in my Book for title page and I wanted to show full month and year (September 2024) I am using '|WFTimeDesc|' In the word doc which is returning abbreviated month with year (Sep 2024), can someone help me on that. Thanks

I'm working on a custom Table View that returns People Planning Plan Data for our users.  The new requirement is to also bring in the Currency of the data. This means I need to bring in the Currency that is assigned to a given Entity (i.e., Currency assigned in Entity Member Properties in the Settings section).  I've looked through the Member, MemberDescription, and MemberProperty Application Database Tables but cannot seem to find where the Currency name is stored.   If anyone can point me to where I can find an Entity's Currency stored in the Application Database Tables, that would be fantastic. 

Does anyone know the BR to change the date format of the Cube view Report footer from ("MM/dd/yyyy h:mm:ss tt") to ("dd/MM/yyyy h:mm:ss tt") via Business Rule Cube view extender? Is there also a rule to show the Username on the Report footer? Would be ideal to show it in the center of the report footer.   Thanks  

Hi All, Can somebody maybe help me on this one? I want to add some subtotals in my report but  the problem is that i need to add two members to the CVR formula. So as shown in the formula below not only deferred taxation (account) but also the UD3 (<1 Year) to get the complete data field to sum. How can this be achieved?      

Hi,We have daily information loaded into OS database and we want to generate different reports and send them via mail. We thought about using parcel service, so we want to include the reports in a book. What are the options for generating reports from the database? Can this only be done using grid views? Is there any option for displaying a dashboard report in a book? Regards,

I can use T#YearPrior1(|WFTime|) in my cube views and it yields the correct date. However, when I use this variable in my ConfirmationRuleArgs, I get an error noting: "Invalid calculation script. Unexpected text. |WFTime|)." Is there a way to have the confirmation rule pull December PY based on the workflow time the user is in?  Thanks for the help!

Hello, Wondering if anyone knows how to have the same Style (Primary, Upper, row/column header, data Styles) as Excel in OS Spreadsheet tool. We have defined in Excel a new custom Primary Style which is visible in the Excel QuickView Settings (under 'Excel Styles)...but it is not visible in OS Spreadsheet tool. Thanks, Regards, Harry  

Hello, I created some vertical stack panel dashboards but when I run them, they all open on the bottom. Is there something I'm missing on why they're not opening to show the first component I've put in? Thanks, Will

Hi - I am currently working on a dashboard that leverages a data adapter to an external database to fetch detailed GL transactions (similar to drillback functionality) and return them in a BI Viewer table within a dashboard.  The SQL statement currently works as intended for when referencing a single, base member account and comparing to a bound account parameter a la: WHERE   sql_data_account = '|OSAccountParameter|' I'd like to modify this so that records are returned for all base members of an account a la: WHERE   sql_data_account IN '|OSAccountParameter|.base' However, I can't get anything similar to the above to work.  I assume it's because '|OSAccountParameter|.base' gets read a string literal.  Any ideas on how I can reference a list of base member given an account provided by a parameter in SQL? Any help will be greatly appreciated!

Hi - I am working on a BI Viewer dashboard and need some help with hyperlink formatting.  I am using a SQL data adapter to an external database which amongst other things, is fetching an internet URL which we are trying to display as a hyperlink with alternative text.  Ideally we'd be able to display text from an alternate line item but I'd settle for something static (i.e. "link").  Thus far I haven't found a way to display anything other than the link text itself and couldn't find anything in the documentation that references the "hyperlink" option under "Data Items / Column Options". Example of current output: Any help would be greatly appreciated!

How can I view more than one plug accounts when doing a report in Intercompamy Matching? Or I can only use one plug account.  

Wondering if anyone knows how to scale data in quick views. Looked through the formatting options and couldn't find anything that would do what I'm looking for. ie. 123,445 can be scaled in thousands to 123. Thanks, Scott

I am looking to extract the data of a selected row in a grid view by click a button inside a dashboard;  

Hi Community...!    I want to perform Threshold operation in FDX report using SQL Query.. Anyone who knows please share the format for reference... Thank You...!