Turbo Integrator: dynamically switching from a text file to a view data source

A forum to post information about tools which are free and open source.
Post Reply
Wim Gielis
MVP
Posts: 3140
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Turbo Integrator: dynamically switching from a text file to a view data source

Post by Wim Gielis »

Hi all,

While I was playing around with some generic processes, I was testing the following setup.
A TI process has a text file data source type, taking the role of a template, from which we can dynamically change to other files / data sources like views, subsets, ODBC, etc.
I allow for 200 variables and mainly did that work in the *.PRO file for the process on the hard drive. Together with Notepad++ to increment series like 1 to 200, this was a breeze.
In the Advanced > Prolog tab of the process, it works fine when I want to dynamically override data source settings.

Then came the task to switch from a text file data source to a view data source. Oops, I got an error: "Variable "NVALUE" not found."
I know that NValue, SValue and Value_Is_String are special system variables: they are only available when the data source type is a view.
Hence, when switching to a view data source type, TM1 is still somehow expecting NValue, SValue and Value_Is_String.
If your process does not have code in the Metadata or Data tabs, then it runs fine (but is pretty useless!).
Once you have only 1 statement in the Metadata or Data tabs, then you receive the error right into your face.

Luckily, Google lead me to viewtopic.php?p=53278#p53278 (lotsaram, Wed Jan 07, 2015 1:00 pm) in the quite long topic found at: viewtopic.php?t=5170

Lotsaram and others were discussing there how to dynamically make the switch. AmbPin had the exact same question (and error) as me. It was suggested that the switch should start from a view data source, not from the text file data source.
This does not particular please me. Why not have a TI process with a text file data source and still being able to make the switch ?
I found out that this is possible. You need to stop the TM1 model and go to the TI process on the hard drive. Open it up in Notepad++ or a different text editor.
You will notice codes. Be careful to only edit the PRO file where I instruct it. Here are the necessary changes/additions:

Code: Select all

In the section for 577, add 3 to the count of lines, and add at the end:
NValue
SValue
Value_Is_String

In the section for 578, add 3 to the count of lines, and add at the end:
1
2
1

In the section for 579, add 3 to the count of lines, and add at the end:
0
0
0

In the section for 580, add 3 to the count of lines, and add at the end:
0
0
0

In the section for 581, add 3 to the count of lines, and add at the end:
0
0
0

In the section for 582, do not change anything !

The count of lines always follows with a comma after the code number (577, 578, ...).
When you are ready, save the PRO file and start the TM1 model again. Now the 3 built-in variables NValue, SValue and Value_Is_String are available.
At the time of dynamically switching to a view data source, all is set and you are good to go.


@rclapp commented that it might be possible to do it with the TM1 REST API. I did not check that out, that's something for tomorrow.


Best regards,

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
MVP
Posts: 3140
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Turbo Integrator: dynamically switching from a text file to a view data source

Post by Wim Gielis »

Ryan was correct (no doubt about that one!)

Here is the JSON body to use in the TM1 REST API to set the variables:
- 200 string variables: V1 to V200
- NValue as a numeric variable
- SValue as a string variable
- Value_Is_String as a numeric variable

Code: Select all

{"Variables": [
        {
            "Name": "V1",
            "Type": "String",
            "Position": 1,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V2",
            "Type": "String",
            "Position": 2,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V3",
            "Type": "String",
            "Position": 3,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V4",
            "Type": "String",
            "Position": 4,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V5",
            "Type": "String",
            "Position": 5,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V6",
            "Type": "String",
            "Position": 6,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V7",
            "Type": "String",
            "Position": 7,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V8",
            "Type": "String",
            "Position": 8,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V9",
            "Type": "String",
            "Position": 9,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V10",
            "Type": "String",
            "Position": 10,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V11",
            "Type": "String",
            "Position": 11,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V12",
            "Type": "String",
            "Position": 12,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V13",
            "Type": "String",
            "Position": 13,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V14",
            "Type": "String",
            "Position": 14,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V15",
            "Type": "String",
            "Position": 15,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V16",
            "Type": "String",
            "Position": 16,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V17",
            "Type": "String",
            "Position": 17,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V18",
            "Type": "String",
            "Position": 18,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V19",
            "Type": "String",
            "Position": 19,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V20",
            "Type": "String",
            "Position": 20,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V21",
            "Type": "String",
            "Position": 21,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V22",
            "Type": "String",
            "Position": 22,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V23",
            "Type": "String",
            "Position": 23,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V24",
            "Type": "String",
            "Position": 24,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V25",
            "Type": "String",
            "Position": 25,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V26",
            "Type": "String",
            "Position": 26,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V27",
            "Type": "String",
            "Position": 27,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V28",
            "Type": "String",
            "Position": 28,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V29",
            "Type": "String",
            "Position": 29,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V30",
            "Type": "String",
            "Position": 30,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V31",
            "Type": "String",
            "Position": 31,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V32",
            "Type": "String",
            "Position": 32,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V33",
            "Type": "String",
            "Position": 33,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V34",
            "Type": "String",
            "Position": 34,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V35",
            "Type": "String",
            "Position": 35,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V36",
            "Type": "String",
            "Position": 36,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V37",
            "Type": "String",
            "Position": 37,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V38",
            "Type": "String",
            "Position": 38,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V39",
            "Type": "String",
            "Position": 39,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V40",
            "Type": "String",
            "Position": 40,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V41",
            "Type": "String",
            "Position": 41,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V42",
            "Type": "String",
            "Position": 42,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V43",
            "Type": "String",
            "Position": 43,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V44",
            "Type": "String",
            "Position": 44,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V45",
            "Type": "String",
            "Position": 45,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V46",
            "Type": "String",
            "Position": 46,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V47",
            "Type": "String",
            "Position": 47,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V48",
            "Type": "String",
            "Position": 48,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V49",
            "Type": "String",
            "Position": 49,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V50",
            "Type": "String",
            "Position": 50,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V51",
            "Type": "String",
            "Position": 51,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V52",
            "Type": "String",
            "Position": 52,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V53",
            "Type": "String",
            "Position": 53,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V54",
            "Type": "String",
            "Position": 54,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V55",
            "Type": "String",
            "Position": 55,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V56",
            "Type": "String",
            "Position": 56,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V57",
            "Type": "String",
            "Position": 57,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V58",
            "Type": "String",
            "Position": 58,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V59",
            "Type": "String",
            "Position": 59,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V60",
            "Type": "String",
            "Position": 60,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V61",
            "Type": "String",
            "Position": 61,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V62",
            "Type": "String",
            "Position": 62,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V63",
            "Type": "String",
            "Position": 63,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V64",
            "Type": "String",
            "Position": 64,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V65",
            "Type": "String",
            "Position": 65,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V66",
            "Type": "String",
            "Position": 66,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V67",
            "Type": "String",
            "Position": 67,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V68",
            "Type": "String",
            "Position": 68,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V69",
            "Type": "String",
            "Position": 69,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V70",
            "Type": "String",
            "Position": 70,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V71",
            "Type": "String",
            "Position": 71,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V72",
            "Type": "String",
            "Position": 72,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V73",
            "Type": "String",
            "Position": 73,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V74",
            "Type": "String",
            "Position": 74,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V75",
            "Type": "String",
            "Position": 75,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V76",
            "Type": "String",
            "Position": 76,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V77",
            "Type": "String",
            "Position": 77,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V78",
            "Type": "String",
            "Position": 78,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V79",
            "Type": "String",
            "Position": 79,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V80",
            "Type": "String",
            "Position": 80,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V81",
            "Type": "String",
            "Position": 81,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V82",
            "Type": "String",
            "Position": 82,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V83",
            "Type": "String",
            "Position": 83,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V84",
            "Type": "String",
            "Position": 84,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V85",
            "Type": "String",
            "Position": 85,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V86",
            "Type": "String",
            "Position": 86,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V87",
            "Type": "String",
            "Position": 87,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V88",
            "Type": "String",
            "Position": 88,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V89",
            "Type": "String",
            "Position": 89,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V90",
            "Type": "String",
            "Position": 90,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V91",
            "Type": "String",
            "Position": 91,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V92",
            "Type": "String",
            "Position": 92,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V93",
            "Type": "String",
            "Position": 93,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V94",
            "Type": "String",
            "Position": 94,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V95",
            "Type": "String",
            "Position": 95,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V96",
            "Type": "String",
            "Position": 96,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V97",
            "Type": "String",
            "Position": 97,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V98",
            "Type": "String",
            "Position": 98,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V99",
            "Type": "String",
            "Position": 99,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V100",
            "Type": "String",
            "Position": 100,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V101",
            "Type": "String",
            "Position": 101,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V102",
            "Type": "String",
            "Position": 102,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V103",
            "Type": "String",
            "Position": 103,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V104",
            "Type": "String",
            "Position": 104,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V105",
            "Type": "String",
            "Position": 105,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V106",
            "Type": "String",
            "Position": 106,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V107",
            "Type": "String",
            "Position": 107,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V108",
            "Type": "String",
            "Position": 108,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V109",
            "Type": "String",
            "Position": 109,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V110",
            "Type": "String",
            "Position": 110,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V111",
            "Type": "String",
            "Position": 111,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V112",
            "Type": "String",
            "Position": 112,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V113",
            "Type": "String",
            "Position": 113,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V114",
            "Type": "String",
            "Position": 114,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V115",
            "Type": "String",
            "Position": 115,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V116",
            "Type": "String",
            "Position": 116,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V117",
            "Type": "String",
            "Position": 117,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V118",
            "Type": "String",
            "Position": 118,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V119",
            "Type": "String",
            "Position": 119,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V120",
            "Type": "String",
            "Position": 120,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V121",
            "Type": "String",
            "Position": 121,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V122",
            "Type": "String",
            "Position": 122,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V123",
            "Type": "String",
            "Position": 123,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V124",
            "Type": "String",
            "Position": 124,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V125",
            "Type": "String",
            "Position": 125,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V126",
            "Type": "String",
            "Position": 126,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V127",
            "Type": "String",
            "Position": 127,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V128",
            "Type": "String",
            "Position": 128,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V129",
            "Type": "String",
            "Position": 129,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V130",
            "Type": "String",
            "Position": 130,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V131",
            "Type": "String",
            "Position": 131,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V132",
            "Type": "String",
            "Position": 132,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V133",
            "Type": "String",
            "Position": 133,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V134",
            "Type": "String",
            "Position": 134,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V135",
            "Type": "String",
            "Position": 135,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V136",
            "Type": "String",
            "Position": 136,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V137",
            "Type": "String",
            "Position": 137,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V138",
            "Type": "String",
            "Position": 138,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V139",
            "Type": "String",
            "Position": 139,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V140",
            "Type": "String",
            "Position": 140,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V141",
            "Type": "String",
            "Position": 141,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V142",
            "Type": "String",
            "Position": 142,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V143",
            "Type": "String",
            "Position": 143,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V144",
            "Type": "String",
            "Position": 144,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V145",
            "Type": "String",
            "Position": 145,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V146",
            "Type": "String",
            "Position": 146,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V147",
            "Type": "String",
            "Position": 147,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V148",
            "Type": "String",
            "Position": 148,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V149",
            "Type": "String",
            "Position": 149,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V150",
            "Type": "String",
            "Position": 150,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V151",
            "Type": "String",
            "Position": 151,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V152",
            "Type": "String",
            "Position": 152,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V153",
            "Type": "String",
            "Position": 153,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V154",
            "Type": "String",
            "Position": 154,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V155",
            "Type": "String",
            "Position": 155,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V156",
            "Type": "String",
            "Position": 156,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V157",
            "Type": "String",
            "Position": 157,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V158",
            "Type": "String",
            "Position": 158,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V159",
            "Type": "String",
            "Position": 159,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V160",
            "Type": "String",
            "Position": 160,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V161",
            "Type": "String",
            "Position": 161,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V162",
            "Type": "String",
            "Position": 162,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V163",
            "Type": "String",
            "Position": 163,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V164",
            "Type": "String",
            "Position": 164,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V165",
            "Type": "String",
            "Position": 165,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V166",
            "Type": "String",
            "Position": 166,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V167",
            "Type": "String",
            "Position": 167,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V168",
            "Type": "String",
            "Position": 168,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V169",
            "Type": "String",
            "Position": 169,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V170",
            "Type": "String",
            "Position": 170,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V171",
            "Type": "String",
            "Position": 171,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V172",
            "Type": "String",
            "Position": 172,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V173",
            "Type": "String",
            "Position": 173,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V174",
            "Type": "String",
            "Position": 174,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V175",
            "Type": "String",
            "Position": 175,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V176",
            "Type": "String",
            "Position": 176,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V177",
            "Type": "String",
            "Position": 177,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V178",
            "Type": "String",
            "Position": 178,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V179",
            "Type": "String",
            "Position": 179,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V180",
            "Type": "String",
            "Position": 180,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V181",
            "Type": "String",
            "Position": 181,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V182",
            "Type": "String",
            "Position": 182,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V183",
            "Type": "String",
            "Position": 183,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V184",
            "Type": "String",
            "Position": 184,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V185",
            "Type": "String",
            "Position": 185,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V186",
            "Type": "String",
            "Position": 186,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V187",
            "Type": "String",
            "Position": 187,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V188",
            "Type": "String",
            "Position": 188,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V189",
            "Type": "String",
            "Position": 189,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V190",
            "Type": "String",
            "Position": 190,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V191",
            "Type": "String",
            "Position": 191,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V192",
            "Type": "String",
            "Position": 192,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V193",
            "Type": "String",
            "Position": 193,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V194",
            "Type": "String",
            "Position": 194,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V195",
            "Type": "String",
            "Position": 195,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V196",
            "Type": "String",
            "Position": 196,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V197",
            "Type": "String",
            "Position": 197,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V198",
            "Type": "String",
            "Position": 198,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V199",
            "Type": "String",
            "Position": 199,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V200",
            "Type": "String",
            "Position": 200,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "NValue",
            "Type": "Numeric",
            "Position": 201,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "SValue",
            "Type": "String",
            "Position": 202,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "Value_Is_String",
            "Type": "Numeric",
            "Position": 203,
            "StartByte": 0,
            "EndByte": 0
        }
    ]}
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
lotsaram
MVP
Posts: 3672
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Turbo Integrator: dynamically switching from a text file to a view data source

Post by lotsaram »

Devil's advocate here. Why do you need rest API? Wouldn't you get exactly the same result if you just used a text file with 202 columns and simply renamed the last 3 variables?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3140
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Turbo Integrator: dynamically switching from a text file to a view data source

Post by Wim Gielis »

That's an option too :-) Making sure that 2 are Numeric, 1 is String.

You could use an Excel file, write V1 and drag it across. Then change the last couple of variables.
Save as TXT and use as the source of a TI process.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply