Dear All,

Created Cube in analysis server2005. we have private dimension as time
with year and period levels.Here problem is, if we upload the data more
than one month, appearing only one month data in the cube.

I.e, if we upload data for May and June month, it is showing only May
month data. But the data is showing in fact table. If we declare period
as one more dimension, then we are able to see all the data.

Here If we miss any thing(setting or way of creation), pls help on
this. Advance thanks to all.........

Cheers,
Chinni

verify that the key columns used for the months (and other levels) provides
a unique key combination.
for example, if the key column contain only "June" and "may", then the June
2004 contains data while June 2005 will be empty. (because the key is June
only)
in this case using 2 key columns or a keycolumn with year and month
information will solve the problem (like June 2004 which is different from
June 2005, so you'll have 2 keys and data for the 2 keys)

does this help you?

"Chinni" <ramesh.pathipati (AT) gmail (DOT) com> wrote

Dear Jeje,

Thanks for your reply. Can you explain to me how to check 2key column
with year and month information. Here we are getting data for month as
numbers in flat file.I.e, 1 means Jan like that.

Cheers,
Chinni
Jéjé wrote:

when you create an attribute in a dimension, you have to define the key
column(s) (1 or more columns) and the name column (1column only)
so, if your key column contain only the month number its not enough.
because AS will not see any difference between month 1 andmonth 1 while
these 2 months are into 2 separate years.
so, if your flat file contain a year column, you have to add this column
into the key columns of the month attribute
now the january month will have a composite key like 2004 + 1 which is
different from 2005 + 1.



"Chinni" <ramesh.pathipati (AT) gmail (DOT) com> wrote

Dear Jeje,

Thanks for your reply. Can you explain to me how to check 2key column
with year and month information. Here we are getting data for month as
numbers in flat file.I.e, 1 means Jan like that.

Cheers,
Chinni
Jéjé wrote: