TM1 Forum

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.co...

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( ...

Hello, You can use: 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=3&t=13333&p=65616&hilit=Expand#p65616 Wim

Thank you Martin

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

Personally I haven't used that API yet so it would be difficult to give assistance.

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 ...

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...

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

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...

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 "netique...

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.

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...

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...

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...

Thank you for the update.

Thank you for the update.

You can turn a dynamic subset into a static subset because you don't want to evaluate the expression anymore. That can improve performance.

Do you have a calculation rule at C level ?

Apologies, I did not answer the question and you can disregard my reply.