TM1 Forum

Why do you activate a range ? OK, fair enough. For a single cell range, I think activate and select end up doing the same thing. I have changed all Range activate command lines to Range Select. In general you don't have to select nor activate ranges and sheets. But I do agree that the problem is in...

zbhmida wrote: ↑Thu Aug 24, 2017 9:52 am Thank you wim,

it works now ^^

Thk you guys
Best regards

You're welcome

Why do you activate a range ?

Now it will become evident: DatasourceASCIIQuoteCharacter = ''; vValeur = 'A ' | Char( 10 ) | ' B ' | Char( 13 ) | ' C '; AsciiOutput( 'test.txt', vValeur ); # replace CRLF nLength = Long( vValeur ); nScan = Scan( Char(13), vValeur ); If( nScan > 0 ); vValeur = Subst( vValeur, 1, nScan - 1 ) | ' ' |...

And what about my solution as a 4th option in your list ?

At least the feeder to (All Time) should be replaced with a feeder to 'a month and its months in the future' consolidation.

This is a calculation for History-to-date values. Just like you have consolidations in the source cube to calculate the History-to-date values, I would use TI to create consolidations in the target cube; for each month there should be a (wisely named) consolidation containing that month AND all the ...

Hello, Welcome on-board. Question. Elements like "2016-xxx CTD", are they consolidated ? If not, can't you feed from an n-level element to the element that you get when you chop off the ' CTD' ? The inverse of adding ' CTD' in the rule, could be a SUBST that takes of the ' CTD' at the end....

Francesca,

Indeed, please provide details.

Also, what about the dimension sizes of the 2 dimensions in the smaller cube ?
In a small, dense, cube, I would not bother with feeding...

You got my vote, I have been in the same boat of reading out *.SUB files, which is an unnecessary overhead.

I voted too !

This is pretty hard to follow but if I can venture a guess: subsets do not change the way elements (consolidations) expand to their children. You need to create custom rollups (consolidations) if you want to have different calculations / different ways to expand a consolidation, and so on. If this i...

Indeed, I was even confused about whether it is 1 cube or 2 cubes in this story...

ITEMREJECT in the Prolog tab is not the correct function here for you, I guess, given that it's the Prolog tab ? ItemReject on the Prolog is quite fine. It is just that as Prolog has no data source and executes only 1x that the ItemReject will skip the rest of the Prolog code from that point. That'...

If I understand you correctly then you only want to put a fed value for 'Cost - standard price' if you have a Quantity. But in reality I would not feed this calculation at all.

ITEMREJECT in the Prolog tab is not the correct function here for you, I guess, given that it's the Prolog tab ?

The feeder should probably read:
If you would zero suppress the rows but not the columns, you would have the same effect without a feeder.

Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??

my question is if I don't have month and year dimensions in target cube which is present in source cube. then what should be the rule, if I hard code it then the value is not flowing correctly from source to target. Please show us your rule and also use real dimension names and cube names. You shou...

Okay, so if you bypass the wizard code of CellPutN and CellGetN, it would be a CellIncrementN function.

I face the same problem but did not spend time on it because that debugger is still new. It would be good if we could reach a solution, maybe with IBM involvement.