TM1 Forum

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

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

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

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 !

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/

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

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

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

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

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

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

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

Here's all the white papers.

Bedrock Modular Approach

Best Practice Turbo Integrator

Best Practice Cube Design

Best Practice Rules

Be curious.

...

You can also look at this previous thread.

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

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.

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 :
But like I said, there will be overfeed .

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

I didn't know that. But even if I remove the '', I still get the error message.

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