Viewing 15 posts - 1 through 15 (of 18 total)
I have been using Excel for last two years, it works fine but once when I tried to create a dimension with 4...
January 21, 2004 at 6:36 am
Do you have all the dimensions that you need in all the four cubes?
January 21, 2004 at 6:24 am
Thanks for the replies and sorry for a delayed response from my side. But I have actually solved this problem with a database procedure.
January 7, 2004 at 5:07 am
Thanks for your reply. But how can I use the same when I have the same situation like this for a customer dimension?
May 12, 2003 at 4:22 am
No, there is no one-to-one relationship between the two set of item numbers.
November 3, 2002 at 9:22 am
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
November 3, 2002 at 4:59 am
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...
October 16, 2002 at 6:27 am
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...
October 14, 2002 at 7:47 am
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,...
October 14, 2002 at 1:09 am
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
October 14, 2002 at 12:43 am
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...
October 14, 2002 at 12:35 am
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...
October 13, 2002 at 11:53 pm
Viewing 15 posts - 1 through 15 (of 18 total)