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...
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...
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:
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...
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...
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...
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.
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...
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...