I have been using Excel for last two years, it works fine but once when I tried to create a dimension with 4...

Do you have all the dimensions that you need in all the four cubes?

Thanks for the replies and sorry for a delayed response from my side. But I have actually solved this problem with a database procedure.

Hi Frank,

It is for reporting purpose.

Anbu

Thanks for your reply. But how can I use the same when I have the same situation like this for a customer dimension?

No, there is no one-to-one relationship between the two set of item numbers.

Hi,

Thanks for immediate reply.

But how does it work when I have the item set with different item numbers (not in order). Like starting from 17 to 22.

Thanks in advance,

Anbu

I post this to be more specific and clear about the problem. This is the sales info for year 1995 and 1996.

USA 5000 6500

Boston 900...

Thanks Andares, It works!

Thanks and regards,

Anbu

sales_item Item Qty

01 05 2

01 06 4

01 ...

Hi

I don't know if this helps you. If you have many fields whose data are in consideration to find the std. deviation, then this is one possiblity.

select stdev(a) from (select...

x is an imaginary table name, that can be anything. You can use all the aggregare functions there. The concept is very simple. I am creating an imaginary table x,...

create table test1 (filed1 int identity, field2 int)

insert into test1(field2) values(1002);

insert into test1(field2) values(1003);

select * from test1

Hope this helps.

Thanks and regards,

Anbu

Hi

I don't know if I have understood you correctly. But my understanding is that you have two tables with the same kind of Mfgpartnumber and cost values.And you need the...

First I created a category level. Then I changed the member key column into

case when Product category in(101,102) then 1 when Product category in(103,104)then 2 end.

I changed...