If you are unable to create a new account, please email support@bspsoftware.com

 

How buils cube from Input file when u have coulm headers.Urgent pls

Started by sys2674, 26 Aug 2005 05:19:16 PM

Previous topic - Next topic

sys2674

Hi I am new to Cognos and have some question
how to create an cube
i wanted to build a power cube of sales history for the sales and marketing departments.

I have one input file for the cube. It will be a big file with duplicate data. when u have a column headres like this

product Sales, Quantities,costs, prices,Item Number,Cust Sort Name
,customer, geography, product, externel sales employee, customer development manager and time.

This gives invoice Qty, sales $, and cost $ for each part for each customer for each period.
We also have salesperson number and item data.

I tried to created this in excel worksheet and inputed one field for each colunm.and saved it as csv.but i could just see the coulmn headers and not the field
suppose colm header "Customer Name" under this i wrote sys but in model i could just see Customer Name and not the field

Urgent help to proceed with this 
Thnx
sys264


cognostechie

You mean in the window 'Data Source' you can only see the column name ? When you say you can see 'Customer Name' and not the field, you mean you cannot see the 'data'?

That's OK. Go ahead and build your dimensions. When the cube is made, the CUBE will get the data. Transformer is just showing you the column names so that you can build your dimensions.Ã, 

There is a way to see the data too in the Transformer. I don't have Powerplay in front of me right now but I think it is in the View menu.

cognostechie

Just to add to my earlier reply, considering you are using a .csv file, Transformer would consider the 'column headers' as your field name.

sys2674

Hi cognostechie,
Thanx for ur help.It was really help to me as being new to cognos.Also i was able to ull the data from txt as well as excel.

Thanx to cognoise.