Cognos Controller

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation. 

Hi Olav

I am using the journals across report, per automatic journal type, for the equity specification. If the minorities are calculated for a subgroup, tic the "automatic journal types as BASE" to only see AJT for the chosen level. (Group and single company or subgroup to be chosen)

I send this report to Excel, and if E700 is defined in a good way, you should be able to re-calculate the minority per account and movement.

Hope this helps!

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation. 

Thanks - I hope the future web versions will allow for direct drilldown :)

------------------------------
Tor Olav Bye-Andersen

Original Message:
Sent: Tue May 14, 2024 07:15 AM
From: Kerstin Kernwein
Subject: E700 - minority interest

Hi Olav

I am using the journals across report, per automatic journal type, for the equity specification. If the minorities are calculated for a subgroup, tic the "automatic journal types as BASE" to only see AJT for the chosen level. (Group and single company or subgroup to be chosen)

I send this report to Excel, and if E700 is defined in a good way, you should be able to re-calculate the minority per account and movement.

Hope this helps!

------------------------------
Kerstin Kernwein

Original Message:
Sent: Fri May 10, 2024 02:38 AM
From: Tor Olav Bye-Andersen
Subject: E700 - minority interest

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation. 

------------------------------
Tor Olav Bye-Andersen
------------------------------

Kerstin's tip about using the "Journals across report, per automatic journal type" with "automatic journal types as BASE" is a great workaround for now.  Exporting that data to Excel can definitely give you a more granular view of what's feeding into the E700 balance.

I agree with you though, it would be fantastic if future web versions of Controller allowed for more direct drilldown capabilities.  Maybe we can upvote this as a feature request on the IBM community page?

Thanks - I hope the future web versions will allow for direct drilldown :)

Hi Olav

I am using the journals across report, per automatic journal type, for the equity specification. If the minorities are calculated for a subgroup, tic the "automatic journal types as BASE" to only see AJT for the chosen level. (Group and single company or subgroup to be chosen)

I send this report to Excel, and if E700 is defined in a good way, you should be able to re-calculate the minority per account and movement.

Hope this helps!

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation. 

Hi,

my view is more from the dataside than consolidation. My idea is, if you have an installation of Planning Analytics (PA) in your company, have a look at the Financial Analytics Publisher (FAP). This little tool can be installed with your CCR installation and is pushing the data into PA-Cubes in real-time. Really nice and smart for analyzing and creating complicated reports.

Regards

Jan

Kerstin's tip about using the "Journals across report, per automatic journal type" with "automatic journal types as BASE" is a great workaround for now.  Exporting that data to Excel can definitely give you a more granular view of what's feeding into the E700 balance.

I agree with you though, it would be fantastic if future web versions of Controller allowed for more direct drilldown capabilities.  Maybe we can upvote this as a feature request on the IBM community page?

Thanks - I hope the future web versions will allow for direct drilldown :)

Hi Olav

I am using the journals across report, per automatic journal type, for the equity specification. If the minorities are calculated for a subgroup, tic the "automatic journal types as BASE" to only see AJT for the chosen level. (Group and single company or subgroup to be chosen)

I send this report to Excel, and if E700 is defined in a good way, you should be able to re-calculate the minority per account and movement.

Hope this helps!

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation. 

Kerstin's tip about using the "Journals across report, per automatic journal type" with "automatic journal types as BASE" is a great workaround for now.  Exporting that data to Excel can definitely give you a more granular view of what's feeding into the E700 balance.

I agree with you though, it would be fantastic if future web versions of Controller allowed for more direct drilldown capabilities.  Maybe we can upvote this as a feature request on the IBM community page?

In the meantime, if you're looking for a wider selection of hardware for your financial reporting needs, check out Frelan Hardware (https://www.frelanhardware.co.uk/) - they have a great selection of tools and equipment.

------------------------------
Frelan Hardware
Mitcham

Original Message:
Sent: Tue May 14, 2024 09:03 AM
From: Tor Olav Bye-Andersen
Subject: E700 - minority interest

Thanks - I hope the future web versions will allow for direct drilldown :)

------------------------------
Tor Olav Bye-Andersen

Original Message:
Sent: Tue May 14, 2024 07:15 AM
From: Kerstin Kernwein
Subject: E700 - minority interest

Hi Olav

I am using the journals across report, per automatic journal type, for the equity specification. If the minorities are calculated for a subgroup, tic the "automatic journal types as BASE" to only see AJT for the chosen level. (Group and single company or subgroup to be chosen)

I send this report to Excel, and if E700 is defined in a good way, you should be able to re-calculate the minority per account and movement.

Hope this helps!

------------------------------
Kerstin Kernwein

Original Message:
Sent: Fri May 10, 2024 02:38 AM
From: Tor Olav Bye-Andersen
Subject: E700 - minority interest

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation. 

------------------------------
Tor Olav Bye-Andersen
------------------------------

hi 

Does anyone have a good way to get more transparancy into the calculations that are made in the Control Table E700 for minority interests - Journalnr. 90?

If I try to drill on the balance I can't get any further than Automatic Journal - 90. Sometimes it is not obvious how the amount is calculated and it would be good to have some transparancy on the amounts that go into the calculation.