Search found 1524 matches

by Wim Gielis
Fri Oct 20, 2017 3:17 pm
Forum: Cognos TM1
Topic: Performance Modeler - Expression Syntax
Replies: 1
Views: 60

Re: Performance Modeler - Expression Syntax

I was able to concatenate strings, but it looks is not working for integers and arithmetic operations. Thank you in advance! Concatenation with the pipe character requires 2 strings. Therefore non numeric components need to be converted to strings and then concatenated. The function Str is a possib...
by Wim Gielis
Fri Oct 20, 2017 3:32 am
Forum: Cognos TM1
Topic: TM1 Turbo Debugger
Replies: 5
Views: 397

Re: TM1 Turbo Debugger

PeteB wrote:
Fri Oct 20, 2017 1:43 am
I have raised the question on the IBM developer Website.
Thank you for the update Peter
by Wim Gielis
Fri Oct 20, 2017 3:30 am
Forum: Cognos TM1
Topic: MDX expession
Replies: 2
Views: 127

Re: MDX expession

I have the below mdx to select the 3 items in level 3 {TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 406],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 407],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 409]}, ALL, RECURSIVE )}, 3)} Why do you include the full path t...
by Wim Gielis
Fri Oct 20, 2017 3:27 am
Forum: Cognos TM1
Topic: Need help to create TI process to copy data
Replies: 5
Views: 223

Re: Need help to create TI process to copy data

Hello, Did you notice that since TM1 10.2.2 FP4 you could use an additional optional parameter which, when you create objects (subsets & views), will make them temporary so no more cleaning needed in the Epilog, they'll be automatically destroyed once the TI process has finished. See : http://www-0...
by Wim Gielis
Fri Oct 20, 2017 3:21 am
Forum: Cognos TM1
Topic: Adding a subset to a dbrw
Replies: 4
Views: 89

Re: Adding a subset to a dbrw

Wim Gielis wrote:
Thu Oct 19, 2017 9:59 pm
Often, trying something takes far less time than posting a question online...
If, however, you think that using a subset name inside a DBRW formula will blow up your TM1 server and turn it into little more than dust: read about this topic here.
by Wim Gielis
Fri Oct 20, 2017 3:12 am
Forum: Useful code, tips and tricks
Topic: Inspecting TM1 processes and chores
Replies: 4
Views: 673

Re: Inspecting TM1 processes and chores

Drg wrote:
Tue Aug 08, 2017 7:05 am
awesome, gret job.
Thank you !
by Wim Gielis
Thu Oct 19, 2017 10:05 pm
Forum: Cognos TM1
Topic: Chore Details
Replies: 6
Views: 94

Re: Chore Details

gtonkin wrote:
Thu Oct 19, 2017 6:27 pm
Pleasure-I guess if you were so inclined, you could build a TI to run through the *.cho and build your own "}Chores" cube with the necessary detail.
Guess what...

http://www.tm1forum.com/viewtopic.php?t=13373

Tom, can you run the processes and provide feedback please ? Thanks!
by Wim Gielis
Thu Oct 19, 2017 9:59 pm
Forum: Cognos TM1
Topic: Adding a subset to a dbrw
Replies: 4
Views: 89

Re: Adding a subset to a dbrw

Often, trying something takes far less time than posting a question online...
by Wim Gielis
Mon Oct 09, 2017 4:19 pm
Forum: Cognos TM1
Topic: replace an element in mdx with a variable
Replies: 1
Views: 64

Re: replace an element in mdx with a variable

vMDX =
‘{
ORDER(
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECURSIVE )},0)}
, [testcube].([Sales Measures].[Full Revenue],[testcty].[‘ | vCountry | ‘]), BASC)
}’;
by Wim Gielis
Sat Oct 07, 2017 1:06 pm
Forum: Cognos TM1
Topic: Using IBM TM1 Turbo integrator Debugger
Replies: 2
Views: 122

Re: Using IBM TM1 Turbo integrator Debugger

Hello,

Are you sure the port number is correct ?
You added EnableTIdebugging=T ?

For me it works fine with:
00.PNG
00.PNG (58.53 KiB) Viewed 100 times
by Wim Gielis
Thu Oct 05, 2017 4:03 pm
Forum: Cognos TM1
Topic: Median in tm1 using mdx sort
Replies: 4
Views: 126

Re: Median in tm1 using mdx sort

Euh... SubsetGetElementName...
Did you check the available functions ?
by Wim Gielis
Tue Oct 03, 2017 9:56 am
Forum: Cognos TM1
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 369

Re: Performance of Architect Vs Perspectives

Can I first ask why a view would take more than 1 quarter to calculate and open ? Why is this ?
by Wim Gielis
Thu Sep 28, 2017 8:52 am
Forum: Cognos TM1
Topic: Excel VBA API Crashing on TM1ObjectListCountGet
Replies: 6
Views: 232

Re: Excel VBA API Crashing on TM1ObjectListCountGet

Hi, Don’t take this the wrong way, but given the other topics of yours, I don’t think the API is the way to go now. You are just starting with TM1 (so it seems) and then you first wed to master TM1 before delving into programming it. For one thing (as Alan pointed out): you will find far better and ...
by Wim Gielis
Wed Sep 27, 2017 6:47 pm
Forum: Cognos TM1
Topic: "invalid string error"- tm1 9.5.2- server explorer
Replies: 5
Views: 127

Re: "invalid string error"- tm1 9.5.2- server explorer

Hi,

I guess this error pops up because you use a wrong element reference.
You can only use the notation !dimension for dimensions that are part of the cube to which the rules are attached.
Can you first verify this ?
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: 194

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: 12
Views: 381

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: 16
Views: 432

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

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: 16
Views: 432

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.