Business Reporter 2 Information Source Issue

Hi @12Guide_PaulB 

Do you have any idea how to resolve this? I saw your comments for business reporter topics therefore i wanted to tag you.

Thanks

Hi gumabs,

The reason for the above error is that DIM_INTERNAL_LEDGER.CODE is not available in the information source ‘GL Balance’. If there are multiple information sources used in a BR report, the Dimensions used in column filters need to be available in information sources used in a sheet. Since it is required to filter HFM Balance by DIM_INTERNAL_LEDGER.CODE by IFRS, as a workaround I can suggest having Internal Ledger Balance (HFM Column) in a separate tab, and from there you can have a vlookup and then get the values to the HFM column in the main tab to check the difference with Statutory Balances. Meaning you can have 2 tabs, 

1st tab to show Statutory Balance using GL balance.

2nd tab to show IL Balance using Internal Ledger Balance

Let me know if the above works or if you need further help in this regard.

Many Thanks,

Sashikala 

Hello @SashikalaP 

I used another work around. I applied additional filter for cell level on HFM Balance cells. It worked

Thanks

Great to hear that you were able to solve it!

Cheers

Sashikala

Hello @gumabs 

I am having the same issue, trying to create a BR with 2 information sources, can you explain the solution you found using filter on cell level plz ?

Thank you

Tanya

Hello @gumabs,

Thanks for your reply ; was wondering from which information source you get your GL balance and your IL balance ? are the sources different ? if yes, how did you combine both ? 

Thank you

Tanya

Hi @MelTanyaS 

You cannot get both GL and IL balances from single source. You must use 2 information sources.