String Feeder Issues

Post Reply
chewza
Regular Participant
Posts: 156
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

String Feeder Issues

Post by chewza »

Hi There

Without going into the full context, I have a recharge template, where user captures the cost centre that a value must be recharges to.

This value is captured into a string element called "SYS - Cost Centre" in the Measures dimension.
So for example, user might capture the string value "CC100".
I have formulas to calculate the values in CC100, and I also need to then feed CC100.

My feeder statement is along the lines of:
['SYS - Cost Centre'] => DB(Cube1,....!Measures (This is actually position of Cost Centre dimension),............)

This does not work.

But it works fine if I change my feeder to explicitly feed for testing purposes to:
['SYS - Cost Centre'] => DB(Cube1,....'CC100' (This is actually position of Cost Centre dimension),............)

Any idea why my original feeder is not working?

I do have a FeedStrings statement.


MAny thanks!!

Regards
Chris
Wim Gielis
MVP
Posts: 3245
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: String Feeder Issues

Post by Wim Gielis »

Hi,

You should replace !Measures with a DB() function towards that measure.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
chewza
Regular Participant
Posts: 156
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: String Feeder Issues

Post by chewza »

Hi Wim

Works perfectly now - thanks very much!!!

Regards
Chris :D
Post Reply