Setting Default Varibale content to "Other" in TI

Post Reply
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Setting Default Varibale content to "Other" in TI

Post by gbehel »

Hello All,

This is with respect to the Data Load using TI Process

After selecting the datasource and prevew data, when I go to variables tab, the default content for all the variables is "Ignore". Is there a way to set this default selection as "Other"

regards
Gbehel
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Setting Default Varibale content to "Other" in TI

Post by lotsaram »

No.

But you can select all fields in the variable type column and change the active dropdown (at the top or bottom of the column depending on which way you drag the selection) and change that field to "other" and all values will be updated. Thus you only need to do this action once and not per variable.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Setting Default Varibale content to "Other" in TI

Post by gbehel »

Thanks Lotsaram,

It helped. Considering i have around 290 variables in one data load file, this suggetion helped in making it quick.

Regards
Gbehel
Post Reply