TM1 Forum

Hi All,

I want to create a report in TM1 persepectives, which could generate top N Projects of a Department at a given time.
Cube: A
Dimension : 1) project 2)Department 3)time 4)Version

Can anyone help me out ?
Thanks !

hi,

i want to show attributes of a metadata dimension in the column field of a view.
for eg i have projects dimension, so i want to make a view with projects in row field and its attributes in column field.

is there any way out ?

making it tab delimited is your best option as you almost never encounter tabs in text data and will never find it in numeric data. If you can't do that then at least have the text data encapsulated inside quotes (") and make sure you don't have any commas inside the numbers. even with a Tab i...

Nidhi wrote:

talsam wrote: what should I do ?

Either change your delimiter or as suggested encapsulate your columns with single quote and in properties change the Quote char = ' and preview your data it should work

did that already...

hi,

whenever i try to upload a .csv file, although the process gets completed but the data is not uploaded correctly. the TI takes the word after comma " , " to the next column, so in that case, my column data are not correct. what should I do ?

qml wrote:Never extract data from reports. Instead, find out which database(s) Qlik is connecting to and pull data straight from there via ODBC.

thanks . i will try .. but what if we dont have access to that database and only qlikview is accessible then what ?

Hi all,
can somebody please tell me how to extract data from qlikview reports into tm1 cube. i googled it all and what i found out was tm1 data into qlikview and not the other way round.
thankyou.

can we edit Views of a Cube , like adding / deleting a dimension ? and can we edit the Subsets of Dimension ?

i have one cube A which contains, lets say, 4 dimensions: name, location, amount, sum total. and other cube b: location, currency, exchange rates. Now i want that if user inputs something in cube A according to the location , then TM1 must take the corresponding exchange rates from cube B , multiple...

Unfortunately I doubt you will get much luck with a question like that. However in order to point you in the right direction search out for IBMs blueprint on a Workforce planning model for starters. Also if you are new to TM1 brush up on some training\tutorial material plenty available online. Fina...

hello guys.. can anybody please help me.. i need to design a cube for HEADCOUNT PLANNING ..i will be calculating the Total headcount comprising of various RGFTEs.. please help me out how to write the rules and feeders for this.. and a basic cube design for this.. i am new to cognos tm1.