Search found 40 matches

by Emixam
Thu Nov 21, 2019 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count distinct rows
Replies: 2
Views: 264

Re: Count distinct rows

I think Ascheevel's solution is the best but if you want to do everything within a TI, you should do something like this : #===================================== # Prolog #===================================== sStringOfInvoices = '' nDistinctInvoices = 0; #===================================== # Dat...
by Emixam
Tue Oct 29, 2019 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Max Value
Replies: 13
Views: 8722

Re: Max Value

Hi, I don't know about the Consolidated Max but maybe this can help. For one of my client, I had to dynamically retrieve the maximum value in a cube. My suggestion is to create a simple TI and do something like this: #==================== # Prolog ( DataSourceType = 'View';) #==================== nM...
by Emixam
Mon Oct 28, 2019 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 1795

Re: TI process question - Mapping greyed out

sorry one more question, somehow the months get sorted wrong (please see attached capture.png), the generated line: DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING'); how can I fix the order so it appears: 01, 02,03....12? thanks! Use the following code. DimensionSortOrder( ...
by Emixam
Tue Oct 22, 2019 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 6126

Best Practice : Migration into a production environment

Hello Guru,

I'm currently doing a migration into a model in production and I have to migrate more than 250 objects (new and some already exist in prod).

What's your best practice to never forget an object ? What's the fastest way to create a migration package ?

Thanks and have a good day !
by Emixam
Tue Sep 17, 2019 6:38 pm
Forum: Commercial and Events
Topic: TM1 coding extension for VSCode
Replies: 13
Views: 18664

Re: TM1 coding extension for VSCode

HighKeys wrote:
Fri Sep 13, 2019 9:23 am
Sorry for the question, but is there any way to get it into normal Visual Studio?


Thanks and BR

Edit:

Long research, its not possible... i managed to get a copy of VS Code for me. :)
Visual Studio Code is available for free.

https://code.visualstudio.com/
by Emixam
Thu Sep 05, 2019 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process: WHILE loop referencing passed parameters
Replies: 6
Views: 1370

Re: TI Process: WHILE loop referencing passed parameters

The only other thing I did was to change '%' | 'pAdd' to '%pAdd' since it was concatenating two strings directly next to each other. Usually I'm using a variable instead of a string. It's less confusing and easily reusable. sSubString = 'Whatever'; sCurrentWhatever = Expand( '%' | sSubString | Numb...
by Emixam
Thu Sep 05, 2019 10:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process: WHILE loop referencing passed parameters
Replies: 6
Views: 1370

Re: TI Process: WHILE loop referencing passed parameters

Do you prefer STR over NumberToString? Fewer parameters and no need to TRIM, I would think. ** I update my code.. It was an old code with STR and TRIM ** Awesome! You're my hero of the week. " No, don't call me a hero. Do you know who the real heroes are? The guys who wake up every morning and go i...
by Emixam
Thu Sep 05, 2019 10:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process: WHILE loop referencing passed parameters
Replies: 6
Views: 1370

Re: TI Process: WHILE loop referencing passed parameters

Hi, You should use the Expand function. I didn't really read your code but here's what your WHILE loop should looks like: WHILE( Counter <= MaxCounter ); sCurrentParam = Expand( '%' | 'pAdd' | NumberToString( Counter ) | '%' ); IF( sCurrentParam @<> ''); DimensionElementInsertDirect( DimName, '', sC...
by Emixam
Thu Sep 05, 2019 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make a server instance available in Tm1 web
Replies: 3
Views: 1243

Re: How to make a server instance available in Tm1 web

Hi, I did a quick google search ( www.google.com ) and I found a bunch of links related to your issue. https://www.tm1forum.com/viewtopic.php?t=13002 https://www.tm1forum.com/viewtopic.php?t=13007 https://cogknowhow.com/t/the-new-tm1-server-is-not-shown-in-the-drop-down-list-for-the-tm1web-login/124...
by Emixam
Wed Sep 04, 2019 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to access newly created tm1 server instance
Replies: 8
Views: 1574

Re: How to access newly created tm1 server instance

spartan wrote:
Wed Sep 04, 2019 8:59 am
I have used data folder from other server instance, hiw to use user/ password from the server.
Did you change the PortNumber ?

A quick google search and I found this : Client shows list of TM1 Servers but cannot connect to any of them
by Emixam
Tue Sep 03, 2019 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to access newly created tm1 server instance
Replies: 8
Views: 1574

Re: How to access newly created tm1 server instance

Hi, Are you able to log on ? Can you show us what you see ? 1) Here's how to add an existing TM1 Server in Cognos configuration: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_tm1_inst_usingcognosconfigurationtoaddanexistingcognostm1server.html...
by Emixam
Thu Aug 29, 2019 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to create dynamic view with the help of MDX?
Replies: 6
Views: 7738

Re: How to create dynamic view with the help of MDX?

Hi, If you want to create a dynamic view and use it as a source in a TI you should do something like this: #============================== # Other Subset : Static #============================== #... #============================== # Account : MDX #============================== sDimAccount = 'GL Ac...
by Emixam
Tue Aug 13, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy cub files
Replies: 4
Views: 1133

Re: Copy cub files

Hi, There's no issue of copying (CTRL-C) a .cub file but there's a risk for sure if you cut (CTRL-X) or delete a cube. Also, don't forget to CubeSaveData(sCube) if you want to most recent data. That being said, I always ask to my collegue to "NEVER TOUCH THE DATA FOLDER WHEN THE SERVER IS RUNNING". ...
by Emixam
Wed Aug 07, 2019 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 1926

Re: Feeder Issue Help Needed

Feeders can be very confusing. I suggest you to read some documentation and also take a look at this previous thread.

https://www.tm1forum.com/viewtopic.php?t=274

In your case, the feeders should be in the Sales Detail cube.

Code: Select all

['Full Revenue'] => DB('AR cube',...,...,...,'Last 3 Month Sales');
by Emixam
Wed Aug 07, 2019 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 1926

Re: Feeder Issue Help Needed

Hi,

I didn't really look at your rules but quickly, if you don't mind about "overfeeding" your model, you should at least do something like that :

Code: Select all

['Full Revenue'] => DB( sCube, ..., ..., 'Last 3 Month Sales');  
But like I said, there will be overfeed .
by Emixam
Fri Aug 02, 2019 8:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 3543

Re: Dynamic query argument in TI...

My preference is to set the whole query up in the local variable DataSourceQuery and then write it out to a file for debugging purposes eg: datasourcequery = 'SELECT * From A_TABLE WHERE NUMERIC_DATE <= ' | nDate ; asciioutput(test.csv',datasourcequery); Thanks David, that's what I did and it works...
by Emixam
Thu Aug 01, 2019 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 3543

Re: Dynamic query argument in TI...

I didn't know that. But even if I remove the '', I still get the error message.
by Emixam
Thu Aug 01, 2019 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 3543

Re: Dynamic query argument in TI...

Hey guys, I have a question for you ! How can I create a dynamic query based on a numeric parameter ? The following code works but I always have a "SQL STATEMENT FAIL" error message (even if i'm able to run my TI successfully). Any Idea how to bypass the error message ? SELECT * From A_TABLE WHERE N...