Datamodel

[NavinReddy]

Dear All,

I created Master Calendar

when i am connecting with this one excel data working fine

In excel i have only two months data ,highlighted only two months ,Here im getting only 12 Months

When i am connection with same location one more excel data,

it has Jan ,Feb ,Mar Data but its showing Jan,Feb,Mar including 12months data(Jan,Feb,Mar+12Months)

Please help me some one

Thanks In Advance

Niranjan

[MK_QSL]

Not understood properly from your description.. Can you please elaborate little bit more ?

[its_anandrjs]

It is due to your Master calender as i under stand try to plot all date dimension like

Year, Month and then check your data which is only 3 months data plot any sum value and check if there is no sum value for rest of the month it shows zero value for that.

Let me know

Regards

[NavinReddy]

Hi Manish,

I have two excels Data i have

first excel sheet i have 2 months data Jan,feb ,here i created master calendar and connected with master calendar here im getting two months data with highleghting

Second excel sheet i have 3 months data Jan,Feb,Mar ,here when i trying to connect with Master calendar

im getting Jan,Feb,Mar +12months

When i select Jan First Excel data im not getting

When i select 12 moths Jan im not getting Second Excel Data

Please give me an idea

Best Regards,

Niranjan

[NavinReddy]

Hi Anand ,

I am not getting how can i fix this error

could you please explan little bit more

Best Regards,

Niranjan

[PrashantSangle]

Hi,

just create one master calender table,

and from both excel table give same name for date field

and then pass that datefield in your master calender.

Regards,

PS

[NavinReddy]

Yes Anand,

When i use no concatination option

Month Data showing like (FEB,JAN,MAR)

like format It May be like this Error

Please any Suggessions

Regards,

Niranjan

[MK_QSL]

Can you share your apps or sample data file?

[its_anandrjs]

I think there is some file problem that you concatenate check your load script it may be like if you use common calender you need is to provide only date column from the tables

Eg:-

//suppose here is Jan, Feb data available

Tab1:

Load

Fieldname as Date ///common date field

From Location;

Concatenate

//And here you have Jan, Feb, Mar data is available

Tab2:

Load

Fieldname as Date ///common date field

From Location;

MasterCalender:

Load

Date,///common date field

Year,

Month

From Location;

After linking you get 12 months and year what ever year you have but data available here is only for Jan,Feb,Mar,Apr,May and do not link your table with any month field.

Regards

[NavinReddy]

while loading how can change the format

Like jan ,feb,mar

month(date#(month)) as month ,

it will work