Search found 1416 matches

by Wim Gielis
Wed Jul 26, 2017 7:08 pm
Forum: Cognos TM1
Topic: Feeders for Rules
Replies: 6
Views: 282

Re: Feeders for Rules

Hello Can you first have a look at the manuals ? I know that the manual on rules isn't top notch but at least the basics are good. As to the questions. Yes, your feeder is correct in that case (without currency USD). The feeder would be: [Currency:'USD', 'Full Revenue'] => ['Global Margin']; The cur...
by Wim Gielis
Tue Jul 25, 2017 8:48 pm
Forum: Cognos TM1
Topic: Feeders for Rules
Replies: 6
Views: 282

Re: Feeders for Rules

Hello, Sorry to say so but there are a number of issues with this rule and feeder. In fact, you made mistakes against all the important aspects of rules and feeders writing here. We'll tackle these points in what follows. - First of all, why not creating a consolidation in the measures dimension? 'F...
by Wim Gielis
Tue Jul 25, 2017 7:35 am
Forum: Cognos TM1
Topic: Concatenated string with Expand Function
Replies: 16
Views: 1036

Re: SubsetElementInsert with index of 0

lotsaram wrote:
Tue Jul 25, 2017 6:58 am
I can't believe I only just found this out. This goes straight into the playbook.
You're welcome.

This one is probably as classic as the one on selecting variable contents in TI: http://www.tm1forum.com/viewtopic.php?f ... 724#p41724
by Wim Gielis
Tue Jul 25, 2017 5:59 am
Forum: Cognos TM1
Topic: Concatenated string with Expand Function
Replies: 16
Views: 1036

Re: Concatenated string with Expand Function

lotsaram wrote:
Tue Jul 25, 2017 4:28 am
What wizardry is this?
You mean to say that all these years of incrementing a counter for adding an element to the end of a subset are wasted!
Exactly ! Those moments are lost and will never come back !
by Wim Gielis
Mon Jul 24, 2017 11:11 pm
Forum: Useful code, tips and tricks
Topic: TM1 Challenge
Replies: 5
Views: 460

Re: TM1 Challenge

Thank you Pandinus for your reaction. I wrote the code (unpolished but it works fine :-) ) and if someone is interested, let me know. I doubt that there will be some interest given that TI code that I find useful (like http://www.tm1forum.com/viewtopic.php?f=21&t=13373 and http://www.tm1forum.com/vi...
by Wim Gielis
Mon Jul 24, 2017 9:39 pm
Forum: Cognos TM1
Topic: Concatenated string with Expand Function
Replies: 16
Views: 1036

Re: Concatenated string with Expand Function

Hi I would go for: SubsetElementInsert( vDimName, vSubsetName, vrollinggroup1, 0 ); SubsetElementInsert( vDimName, vSubsetName, vrollinggroup2, 0 ); SubsetElementInsert( vDimName, vSubsetName, vrollinggroup3, 0 ); SubsetElementInsert( vDimName, vSubsetName, vrollinggroup4, 0 ); SubsetElementInsert( ...
by Wim Gielis
Fri Jul 21, 2017 6:46 pm
Forum: Cognos TM1
Topic: Concatenated string with Expand Function
Replies: 16
Views: 1036

Re: Concatenated string with Expand Function

Hello,

You can use:

Code: Select all

vcount=1;
While(vcount<=12);
SubsetElementInsert(vDimName, vSubsetName, Expand('%vrollinggroup'|NumberToString(vcount) |'%'), vcount);
Vcount=vcount+1;
END;
Another topic that uses Expand:
http://www.tm1forum.com/viewtopic.php?f ... and#p65616

Wim
by Wim Gielis
Thu Jul 20, 2017 11:43 pm
Forum: General
Topic: Upcoming server migration
Replies: 12
Views: 824

Re: Upcoming server migration

Thank you Martin
by Wim Gielis
Fri Jul 14, 2017 4:26 pm
Forum: Cognos TM1
Topic: Is it still worth working on a cube auto promotion tool?
Replies: 11
Views: 695

Re: Is it still worth working on a cube auto promotion tool?

JulianS wrote:I'm gonna leave the VBA alone,
Is it a treeview that you use in the Userform ?
That object does not play nicely in several versions of Excel, or Excel 64 bits.
I know that Excel MVP Jan-Karel Pieterse offers a free alternative with classes:
http://www.jkp-ads.com/articles/treeview.asp
by Wim Gielis
Tue Jul 11, 2017 3:56 pm
Forum: Cognos TM1
Topic: JAVA API get view array with header???
Replies: 6
Views: 562

Re: JAVA API get view array with header???

Personally I haven't used that API yet so it would be difficult to give assistance.
by Wim Gielis
Tue Jul 11, 2017 3:55 pm
Forum: Cognos TM1
Topic: Subset present but with no code in its dimension process
Replies: 6
Views: 419

Re: Subset present but with no code in its dimension process

Hello srp, Regarding the subset, can you open up the relevant *.sub file in the data directory ? Go to the folder of the subsets of the dimension, and use Notepad for example to open the *.sub file. With parameter 11, do you see a timestamp ? Regarding the other question, it's better to start a new ...
by Wim Gielis
Mon Jul 10, 2017 5:24 pm
Forum: Cognos TM1
Topic: Subset present but with no code in its dimension process
Replies: 6
Views: 419

Re: Subset present but with no code in its dimension process

Hello there, You need to look for the functions SubsetCreate and SubsetCreateByMDX, possibly with a text editor like Notepad++. Are there other processes that are executed that contain such code ? You're sure that you can create the subsets with a certain TI because before the process runs they do n...
by Wim Gielis
Mon Jul 10, 2017 6:07 am
Forum: Cognos TM1
Topic: TM1 Performance modeler Login issue
Replies: 8
Views: 306

Re: TM1 Performance modeler Login issue

krithika331 wrote:
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\tunit
ForceReevalutionOfFeedersForFedCellsOnDataChange=T
Could it be a typo? You're missing an a.

ForceReevaluationOfFeedersForFedCellsOnDataChange
by Wim Gielis
Mon Jul 10, 2017 12:33 am
Forum: Cognos TM1
Topic: CELLPUTN
Replies: 19
Views: 845

Re: CELLPUTN

Dear Julian, It's humble that you help others, we all do. Not only during the day, also in the evening and during weekends. However, your negative comments addressing me personally in this topic are very unprofessional and even low-level. I leave it to the moderators to decide how to rate these pick...
by Wim Gielis
Sun Jul 09, 2017 9:46 pm
Forum: Cognos TM1
Topic: CELLPUTN
Replies: 19
Views: 845

Re: CELLPUTN

I have also noticed your negativity towards users Could it possibly because its easier to be be a critic than a creator? JulianS, Always funny, people like you. You registered 3 days ago, so please make comments only once you get to know the environment a little bit. And do learn some "netiquette" ...
by Wim Gielis
Sat Jul 08, 2017 9:52 pm
Forum: Cognos TM1
Topic: CELLPUTN
Replies: 19
Views: 845

Re: CELLPUTN

Jules,

Thank you for your contribution.
Why do you use the destination cube as the data source ?
To me it makes more sense to use the input cube as the data source. With an extra measure (Treated, 0 or 1) and a simple loop as explained above, this is not difficult to do.
by Wim Gielis
Fri Jul 07, 2017 2:11 pm
Forum: Cognos TM1
Topic: CELLPUTN
Replies: 19
Views: 845

Re: CELLPUTN

It complicates matters if StartDate and/or FinishDate is empty, but if they were both non-empty or both empty, then this will work: Create a view on Cube1 in the Prolog section of the Advanced tab. Select in the dimension Details on element StartDate. That way, you can loop over all non-zero StartDa...
by Wim Gielis
Fri Jul 07, 2017 11:26 am
Forum: Cognos TM1
Topic: CELLPUTN
Replies: 19
Views: 845

Re: CELLPUTN

If you compare strings these should be in the same format. For example: yyyymmdd on both sides of the inequality. Can you provide more information ? What business problem do you want to tackle ? Which cubes do you have ? Which dimensions ? Besides the looping, do you use a view for the data source o...
by Wim Gielis
Fri Jul 07, 2017 10:00 am
Forum: Cognos TM1
Topic: CELLPUTN
Replies: 19
Views: 845

Re: CELLPUTN

Dear friend, This is not an enhancement, so you are posting in the wrong subforum. You registered to this forum more than 3 years ago, so this should not be new to you. I assume this topic will be moved shortly. and im sure you cant do <= and => between strings. True, but you can use @<= and @=> whe...