Forum Replies Created

Viewing 15 posts - 1 through 15 (of 18 total)

  • RE: Tools for users to browse Cubes?

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

  • RE: Drill through issues in virtual cubes

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

  • RE: Previous non zero value

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

  • RE: Previous date's value

    Hi Frank,

    It is for reporting purpose.

    Anbu

  • RE: Aggregates sums in dimension level

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

  • RE: updates within the same table

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

  • RE: updates within the same table

    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

  • RE: share of sales %

    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...

  • RE: Share of sales %

    Thanks Andares, It works!

    Thanks and regards,

    Anbu

  • RE: Share of sales %

    sales_item Item Qty

    01 05 2

    01 06 4

    01 ...

  • RE: Cross-column calculations

    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...

  • RE: select statement

    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,...

  • RE: random query

    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

  • RE: select statement

    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...

  • RE: Artifical level in dimensions

    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...

Viewing 15 posts - 1 through 15 (of 18 total)