Search found 1473 matches

by Wim Gielis
Mon Aug 21, 2017 9:15 pm
Forum: Cognos TM1
Topic: Feed from C level
Replies: 8
Views: 206

Re: Feed from C level

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.
by Wim Gielis
Mon Aug 21, 2017 8:43 pm
Forum: Cognos TM1
Topic: Feed from C level
Replies: 8
Views: 206

Re: Feed from C level

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 ...
by Wim Gielis
Mon Aug 21, 2017 6:09 pm
Forum: Cognos TM1
Topic: Feed from C level
Replies: 8
Views: 206

Re: Feed from C level

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. If an ele...
by Wim Gielis
Mon Aug 21, 2017 2:11 pm
Forum: Cognos TM1
Topic: OVERFEEDING issue
Replies: 3
Views: 148

Re: OVERFEEDING issue

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...
by Wim Gielis
Mon Aug 21, 2017 8:36 am
Forum: Cognos TM1
Topic: SubsetElementGetIndex TI function
Replies: 9
Views: 660

Re: SubsetElementGetIndex TI function

You got my vote, I have been in the same boat of reading out *.SUB files, which is an unnecessary overhead.
by Wim Gielis
Sun Aug 20, 2017 7:32 pm
Forum: Cognos TM1
Topic: SubsetElementGetIndex TI function
Replies: 9
Views: 660

Re: SubsetElementGetIndex TI function

I voted too !
by Wim Gielis
Wed Aug 16, 2017 8:36 pm
Forum: Cognos TM1
Topic: Custom subsets for reporting view issue
Replies: 1
Views: 162

Re: Custom subsets for reporting view issue

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...
by Wim Gielis
Wed Aug 16, 2017 1:34 pm
Forum: Cognos TM1
Topic: Feeder for rule used in DB Function
Replies: 12
Views: 538

Re: Feeder for rule used in DB Function

Indeed, I was even confused about whether it is 1 cube or 2 cubes in this story...
by Wim Gielis
Tue Aug 15, 2017 6:35 am
Forum: Cognos TM1
Topic: subset creation moved to epilog and worked
Replies: 5
Views: 375

Re: subset creation moved to epilog and worked

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'...
by Wim Gielis
Mon Aug 14, 2017 10:00 pm
Forum: Cognos TM1
Topic: Feeder for rule used in DB Function
Replies: 12
Views: 538

Re: Feeder for rule used in DB Function

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.
by Wim Gielis
Mon Aug 14, 2017 7:06 pm
Forum: Cognos TM1
Topic: subset creation moved to epilog and worked
Replies: 5
Views: 375

Re: subset creation moved to epilog and worked

ITEMREJECT in the Prolog tab is not the correct function here for you, I guess, given that it's the Prolog tab ?
by Wim Gielis
Mon Aug 14, 2017 7:00 pm
Forum: Cognos TM1
Topic: Feeder for rule used in DB Function
Replies: 12
Views: 538

Re: Feeder for rule used in DB Function

The feeder should probably read:

Code: Select all

['Total Qty on Hand'] => ['Cost - Standard Price'];
If you would zero suppress the rows but not the columns, you would have the same effect without a feeder.
by Wim Gielis
Sun Aug 13, 2017 12:41 pm
Forum: Cognos TM1
Topic: Fresher..Rules & Feeders
Replies: 9
Views: 736

Re: Fresher..Rules & Feeders

Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??
by Wim Gielis
Sun Aug 13, 2017 10:30 am
Forum: Cognos TM1
Topic: Fresher..Rules & Feeders
Replies: 9
Views: 736

Re: Fresher..Rules & Feeders

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...
by Wim Gielis
Sat Aug 12, 2017 3:31 pm
Forum: Cognos TM1
Topic: Store values VS. Accumulate values
Replies: 10
Views: 497

Re: Store values VS. Accumulate values

Okay, so if you bypass the wizard code of CellPutN and CellGetN, it would be a CellIncrementN function.
by Wim Gielis
Fri Aug 11, 2017 12:02 am
Forum: Cognos TM1
Topic: TM1 Turbo Debugger
Replies: 2
Views: 271

Re: TM1 Turbo Debugger

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.
by Wim Gielis
Thu Aug 10, 2017 4:51 pm
Forum: Cognos TM1
Topic: Feeder for rule used in DB Function
Replies: 12
Views: 538

Re: Feeder for rule used in DB Function

Analytics123 wrote:
Thu Aug 10, 2017 4:33 pm
Is my feeders correct ?
No. Didn't TM1 complain when you wanted to save it?

In any case, the left hand side of a feeder rule is always an area in a cube specified with the [ ] notation. The DB function will follow after the arrow of the feeder.
by Wim Gielis
Thu Aug 10, 2017 7:12 am
Forum: Cognos TM1
Topic: TM1 Migration between different environments
Replies: 4
Views: 422

Re: TM1 Migration between different environments

Hello,

Why do you need to make it so complicated ?
Isn't this just a Find / Replace in *.PRO files of the data directory,
after which you need to bounce the TM1 model (restart the service) to take the changes in effect.
This last step is what you are missing in my opinion in your python script.
by Wim Gielis
Thu Aug 10, 2017 6:22 am
Forum: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 830

Re: Is there a free way to move data from cube to Tableau?

Correct, a Tableau forum will probably give you the answers.
by Wim Gielis
Wed Aug 09, 2017 8:08 pm
Forum: Cognos TM1
Topic: how to post value to console cube
Replies: 6
Views: 388

Re: how to post value to console cube

Hello, To make this code dynamic, you will need code to: 1. create the source view (on the cube holding the white cells to be transferred) 2. create the target view (on the cube receiving the data). You use the function ViewZeroOut on the view (not on the first view!) See here for code: http://www.t...