Search found 1509 matches

by Wim Gielis
Sat Sep 23, 2017 4:58 pm
Forum: Cognos TM1
Topic: Best Practice to save Rules Values as Stored Values
Replies: 2
Views: 117

Re: Best Practice to save Rules Values as Stored Values

Usually, one would write a TI process to save the values in the other cube.
Rules will always be dynamic, also in small cubes, so if you want static values, the only way to to it using a TI process (or manual copy/paste).
by Wim Gielis
Fri Sep 22, 2017 11:28 am
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 11
Views: 175

Re: Undo after save in Excel 2016 with TM1 add in

Hi, Big problem ! Environment: Office 32 bit Microsoft Office 365 Business Version 1707 (build 8326.2107 click-to-run) PAL (TM1 11.0.200.998) It's not linked to the new auto save functionality because it's turned off for me now. 1. Create a new workbook (Ctrl-N) 2. Change 1 cell 3. Save the file to ...
by Wim Gielis
Fri Sep 22, 2017 10:37 am
Forum: Cognos TM1
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 15
Views: 274

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Also, have a look at whether the source cells, if rules-calculated, are fed or not.
by Wim Gielis
Fri Sep 22, 2017 8:14 am
Forum: Cognos TM1
Topic: dynamic subset for last 5
Replies: 1
Views: 35

Re: dynamic subset for last 5

The last 5 elements of a dimension, or the last 5 children/descendants ?

If the former:

{Tail( TM1SubsetAll( [segment] ), 5 )}

If the latter, I'll leave it as an exercise for you.
by Wim Gielis
Fri Sep 22, 2017 6:36 am
Forum: Cognos TM1
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 15
Views: 274

Re: Rules Created by Links are not allowing us to copy data from source version to target version

rajeshdayaneni wrote:
Fri Sep 22, 2017 6:07 am
Hi lotsaram ,

Cube has 7 dimensions and the process took 30 sec to complete.

Regards,
Rajesh Dayaneni
Hello,

This seems rather unlikely and points to the fact that from and to view have been messed up or interchanged.
by Wim Gielis
Wed Sep 20, 2017 10:49 pm
Forum: Cognos TM1
Topic: adding elements in dimesnion using TI
Replies: 3
Views: 99

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: 169

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: 86

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: 131

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: 131

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: 146

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: 315

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: 140

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: 261

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: 135

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: 241

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: 388

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: 317

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: 206

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.