OneStream Community

SC · 06-20-2022

Hi, Would be great to get your thoughts on the below: I have 2 cubes with 2 different time profiles attached – Standard (Jan-Dec) and AugYearEnd (Sep – Aug) I have used the below query successfully in CVs to get the time description based on the cube...

SC · 04-29-2022

Hi experts, I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances.I thought this would be easy enough with a derivative rule; first create an interim rule to aggregate the accounts and then c...

SC · 04-20-2022

Hi experts, The business users had posted some retained earnings adjustments to both base and parent entities at OwnerPostAdj consolidation level. I have a very simple opening balance rule that works across all entities and consolidation levels: api....

SC · 04-04-2022

Hi experts. I have a query with regards to drill-down feature to locate the journals from 'AdjConsolidated' member. The entity hierarchy of the client has multiple levels and they post journals at each of this level (i.e at parents as well as base en...

SC · 12-06-2021

Hi Experts, I have the following rule to translate my opening balance adjustment (entered manually in the current year) at an opening rate. If (api.Cons.IsCurrency() And Not api.Cons.IsLocalCurrencyforEntity()) Then 'Only run for foreign currency Dim...

SC · 09-18-2023

Hi, I don't see an issue if you are not changing the consolidation and ownership percentages in the existing entity structure. I would be more interested to understand if this does create any issue if you were to make the % changes in the existing en...

SC · 03-20-2023

Hi,You can use an XFBR rule to dynamically retrieve the scenarios in the report columns based on the current period selection. Use View as 'Periodic' for the respective columns with a 'Total' column at the end. Regards,S

SC · 04-29-2022

Hi Nic,Based on what you suggested, this is what I tried: 1. Aggregate the accounts into Map_SwapProd2. Multiply by 1 and create Map_SwapProd_New3. Check if Map_SwapProd_New >0 0r <0 and map to Map_SwapProd_Po / Map_SwapProd_Ne In my transformation r...

SC · 04-29-2022

Thanks for your response Nic. So, you are saying I can't get this working through a >x and

SC · 04-25-2022

Hi,I had noticed that one too. But fortunately, the actual report runs based on the workflow selection. So, if you have selected 'Sales_Volume_GL' in the WF and then go to the report, it will still show Trial_Balance in the selection, but when you ru...

OneStream Community

User Statistics

User Activity

Time Description for non standard time profiles

Derivative rules

Opening balance calculation on OwnerPostAdj

Drill down to all journals from AdjConsolidated member

Translate Opening Balance Adjustment member at Opening Rate

Re: Considerations for Changing Cube Consolidation Algorithm Type

Re: QTD Column in a Cube View

Re: Derivative rules

Re: Derivative rules

Re: Export Invalid intersections including validation messages