Feeding calculated consolidated cell

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Feeding calculated consolidated cell

Post by kenship »

Hi,

I need some help in feeding a calculated consolidated cell. The attachment shows the test cube.

A simple explanation of what I'm trying to do here: I'm trying to have % calculation based on "Change" divided by "Opening" but only on subtotal level.

I tested feeders on detail level and it works but once changing the rule to calculate on C: level it won't.

Any help is appreciated.

Kenneth

Code: Select all

Skipcheck;
['%']=C:
	DB('Test', 'Change', !zA, '$')
	\
	DB('Test', 'Opening', !zA, '$')
;

Feeders;
['$'] => ['%'];
Screenshot 2021-06-11 134513.png
Screenshot 2021-06-11 134513.png (78.98 KiB) Viewed 4924 times
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Feeding calculated consolidated cell

Post by Wim Gielis »

Do you need to feed anyway, or can you for example work with fixed report layouts ?
At least for the cells involved in the calculations, or can they be put alongside fed cells in the same report and don't need feeding themselves ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: Feeding calculated consolidated cell

Post by kenship »

Hi Wim,

Thanks for the response. Unfortunately the answer is yes. Basically the whole purpose is to get the % calculation on consolidated level only.

In the example shown, I need the 43.53% and couldn't show it unless the % calculation is applied to all leaf elements.

Kenneth
Wim Gielis wrote: Fri Jun 11, 2021 7:56 pm Do you need to feed anyway, or can you for example work with fixed report layouts ?
At least for the cells involved in the calculations, or can they be put alongside fed cells in the same report and don't need feeding themselves ?
burnstripe
Regular Participant
Posts: 197
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Feeding calculated consolidated cell

Post by burnstripe »

Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: Feeding calculated consolidated cell

Post by kenship »

Great idea!

Will definitely try and report.

Thanks a lot!

Keneth

burnstripe wrote: Sun Jun 13, 2021 10:40 am Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Feeding calculated consolidated cell

Post by lotsaram »

burnstripe wrote: Sun Jun 13, 2021 10:40 am Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.
This is the way.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: Feeding calculated consolidated cell

Post by kenship »

The suggestion to make % the parent of $ works.

Thanks a lot!

Kenneth
Post Reply