Search found 1504 matches

by Wim Gielis
Wed Sep 20, 2017 10:49 pm
Forum: Cognos TM1
Topic: adding elements in dimesnion using TI
Replies: 3
Views: 92

Re: adding elements in dimesnion using TI

You could use code like:

Code: Select all

DimensionElementInsert( ‘dim’,’’,vCity,’C’);

DimensionElementInsert( ‘dim’,’’,vCity | ‘ - Building NA’,’N’);
DimensionElementComponentAdd( ‘dim’,vCity,vCity | ‘ - Building NA’,1);
by Wim Gielis
Wed Sep 20, 2017 1:33 pm
Forum: Cognos TM1
Topic: fileexists and dimensionexists
Replies: 8
Views: 155

Re: fileexists and dimensionexists

One option is:

Above the ProcessQuit, add a line with the LogOutput function. Then you get the message you want in the message log. If you want to have the messsage in a different way, please give more context.
by Wim Gielis
Wed Sep 20, 2017 6:01 am
Forum: Cognos TM1
Topic: How to Feed this Rule ??? pls help!!!
Replies: 2
Views: 76

Re: How to Feed this Rule ??? pls help!!!

Try to find a candidate for the feeder in cube2. That will probably be the best solution.
Otherwise start the feeder in cube1 and overfeed.
Or try a situation without feeding.
Or even try a solution without Skipcheck in cube2.
by Wim Gielis
Tue Sep 19, 2017 11:16 am
Forum: Cognos TM1
Topic: TI view wizard filters by code?
Replies: 5
Views: 127

Re: TI view wizard filters by code?

Why not do the filtering in the Data tab of the process ?
And the Prolog tab contains a larger view (unfiltered).
by Wim Gielis
Mon Sep 18, 2017 11:41 pm
Forum: Cognos TM1
Topic: TI view wizard filters by code?
Replies: 5
Views: 127

Re: TI view wizard filters by code?

Hello,

If you are on Planning Analytics, check out this function: ViewCreateByMDX

https://www.ibm.com/support/knowledgece ... bymdx.html

Does this help ? I did not play around with the function yet.
by Wim Gielis
Sat Sep 16, 2017 8:09 pm
Forum: Cognos TM1
Topic: carryforward ending balance to beginning balance
Replies: 1
Views: 145

Re: carryforward ending balance to beginning balance

Hello, The view for your datasource needs to be scripted using parameters such as pYear and pMonth. Then in the Advanced > Data tab, do a CellPutN using an attribute on the Month / Period / ... dimension, to know the "Next Month". Also, in the Prolog tab, you will need to a zero out of the data in t...
by Wim Gielis
Sat Sep 16, 2017 4:55 pm
Forum: Cognos TM1
Topic: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect
Replies: 8
Views: 311

Re: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect

Use the Advanced > Metadata tab with functions like:
DimensionElementInsert
DimensionElementComponentAdd
If-Else-EndIf

Nothing more than that.
by Wim Gielis
Sat Sep 16, 2017 12:41 pm
Forum: Cognos TM1
Topic: Monthly Poll 201709_10
Replies: 2
Views: 129

Re: Monthly Poll 201709_10

Well, for me the reverse in fact, although I hate it when the icons shrink and all misery you wrote about, Paul. If I were the one who decides, I would not make a ribbon for Excel 2007. That's 10 years old now and a bad Excel version. Related thoughts: I have my own ribbon for (mainly) Excel tools b...
by Wim Gielis
Sat Sep 16, 2017 9:07 am
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 236

Re: Creating Cube Generates "Cell type is string" error

It's really just as simple as this. Elements in dimensions are strings, text. Like cost center "Facility" or month "March" or customer "XYZ". Also Year 2017 is a string, it's not the number 2017. You create / update the dimensions either manually, either with a process. But the data they contain whe...
by Wim Gielis
Fri Sep 15, 2017 6:23 am
Forum: Cognos TM1
Topic: Not Fed issue
Replies: 6
Views: 253

Re: Not Fed issue

Please have a look at the other topic yourself.
There are already feeders in there, by JulianS.
by Wim Gielis
Tue Sep 12, 2017 11:56 pm
Forum: Cognos TM1
Topic: User defined consolidations in a slice
Replies: 4
Views: 130

Re: User defined consolidations in a slice

Hello

Why don't you use a simple TI process to update the hierarchy? It can be executed with an Action button in Excel and TM1Web.
by Wim Gielis
Thu Sep 07, 2017 8:27 pm
Forum: Cognos TM1
Topic: Tm1 public subsets gets cleared
Replies: 5
Views: 237

Re: Tm1 public subsets gets cleared

If you don't delete elements from the dimension, this cannot be the reason that subsets would lose their elements. What you do is unwinding in the dimension (which is good and I also do that) but as Lotsaram already wrote unwinding is not the cause, it's deleting and reinserting elements.
by Wim Gielis
Tue Sep 05, 2017 11:41 pm
Forum: Cognos TM1
Topic: TM1RPTROW Repeat Problem
Replies: 19
Views: 381

Re: TM1RPTROW Repeat Problem

What happens if you recreate the active form in the cube viewer, with the same MDX and the same selections ? Does it work ?
Is the behavior the same as in TM1Web ?
by Wim Gielis
Tue Sep 05, 2017 8:28 pm
Forum: Enhancements
Topic: Dimix with non-existing dimension
Replies: 2
Views: 312

Re: Dimix with non-existing dimension

Hi Jim,

It would be quite a change (also in other clients next to TI ) and I am also rather confident that IBM won't do this.

Wim
by Wim Gielis
Mon Sep 04, 2017 9:03 am
Forum: Cognos TM1
Topic: Transfer data in the cube to a specific cell
Replies: 4
Views: 198

Re: Transfer data in the cube to a specific cell

Hello Wirt,

It means that you need to supply the correct arguments to the functions CellIsUpdateable, CellPutN, CellPutS, ...
This depends on your cube structure and it's only that can do this because you know the cube structure, the variables, and so on.
by Wim Gielis
Sat Sep 02, 2017 12:13 pm
Forum: Enhancements
Topic: Dimix with non-existing dimension
Replies: 2
Views: 312

Dimix with non-existing dimension

Hello, What do you think ? I misspelled a dimension name lately in a TI process. I used the wrong dimension name in a Dimix formula, to check in the metadata tab whether an element is new or not. The Dimix gives 0 as the result. Wouldn't it be an enhancement if it gave an error rather than 0, for di...
by Wim Gielis
Fri Sep 01, 2017 9:00 am
Forum: Cognos TM1
Topic: 'OldCubeLogChanges'
Replies: 4
Views: 145

Re: 'OldCubeLogChanges'

It's just the name of a variable.
That variable stores the value of 0 or 1, whether logs should be recorded or not. During the process we tend to disable transaction logging (put it to 0) while at the end of the process in the Epilog tab we restore the initial value (taken from the variable).
by Wim Gielis
Thu Aug 31, 2017 4:51 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 287

Re: ASCIIOUTPUT to csv to show data in different columns

lotsaram wrote:
Thu Aug 31, 2017 12:18 pm
Interesting, I guess you never know until you try!
That's what I did :-)
by Wim Gielis
Thu Aug 31, 2017 4:05 pm
Forum: Cognos TM1
Topic: How to get an automatic cubeview refresh with TI Process
Replies: 5
Views: 135

Re: How to get an automatic cubeview refresh with TI Process

Unless I'm mistaken, you will always have some sort of refresh or recalculate action.
by Wim Gielis
Thu Aug 31, 2017 7:51 am
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 287

Re: ASCIIOUTPUT to csv to show data in different columns

Well you are stuck my friend as TM1 only provides the local variables DatasourceASCIIDelimiter & DatasourceASCIIQuoteCharacter which apply to BOTH the text file being read AND the text file(s) being exported. You would think it would be sensible to have separate variables but fact is we don't. So t...