Hi All,

I am currently working in Cognos and can create alternative drill down
paths. I need to be able to do the same thing in analysis services as we are
migrating all our cubes over provided we can do this

i.e.
Dimension
Date
All Dates
1 Month ago
2 Months Ago
By Week

etc

Or another example of one of the hierachy's

Org Group Org Type
Brand
Casino



Please can someone help me - I am in desperate need of help - even if it is
just to point me in the right direction

Thanks

i believe that is just a dimension hierarchy

isn't it?

there is a wizard to do that thing-- basically you can have a TIME.CALENDAR
dimension and a TIME.FISCAL dimension.

That's all you're looking for, right?

-Aaron

"Dragon" <Dragon (AT) discussions (DOT) microsoft.com> wrote

Hi Aaron

Thanks for the help - this is not quite what I want
For instance on the time dimension - I want them all on the same level

All Dates
1 Month ago
2 Months Ago
By Week

and in this example Casino Dimension - there would be alternative drill
downs i.e. the user could either drill down on org group or org type (org
group and org type are essentially on the same level)
I hope this makes better sense - any suggestions?

Org Group Org Type
Brand
Casino


"aaron kempf" wrote:

then do it as a view and report on it in OLAP

it really woudln't be that hard to do




"dragon" <dragon (AT) discussions (DOT) microsoft.com> wrote

I just don't understand what you want.

I swear, a standard time dimension would allow you to view any one of these
periods without any extra help-- are you looking to compare months to weeks;
etc?

so you want to see
SALES
All Dates 20000000
1 Month ago 1120000
2 Months Ago 2200000
By Week 450000

is that what you want? I think that you'll need to write those as MDX; and
I'm not so hot at MDX.. im more of a cube/mart developer.. if i were you;
i'd repost this under the title MDX and say you need to write this as MDX
and see what you get.. I think you'd get an answer..

It seems like you could just union this data in a view-- really depends on
what granularity you have the data-- you wouldn't want to union a few
billion records; or anything... but you could sure do it if you needed to
and you had the right hardware.. then have a dimension that is like period
type-- that would be totally doable.

and then it seems like orgType and orgGroup as seperate dimensions-- that
part of it seems mass straight forward.

btw, what casino?? i just was down in vegas and won/had a blast at the
stratosphere.. i lost a TON of money everywhere else I went

i was kinda sour, i invited this one chick; and then my girlfriend found out
like 3 days before i left; and girlfriend bought a ticket and followed me
down there and the first chick chickened out.. LoL






"dragon" <dragon (AT) discussions (DOT) microsoft.com> wrote

Hi Aaron,

I can see why you can't see what I am getting at - in fact creating these
hierachies was quite simple and I have managed to do it. I just wasn't seeing
the results in AS but when I opened it in Cognos there they were.
Thank you for all your help though.

I have another question however about the same subject
If I create the following dimensions
Date.Year
Date.Month
Date.Week

I get the following when I view it in Cognos

Date
2002
2003
2004
By Month
By Week

How do I get it as follows

Date
By Year
By Month
By Week

I read somewhere about using a default but I can't find where I read it

Thanks again

PS Sounds like you had loads of naughty fun in Vegas, I would absolutely
love to visit it someday - I believe it is spectacular.
We are an online casino not a land based casino
Have a look ... www.fortunelounge.com

Cheers



"aaron kempf" wrote:

I just dont know, I havent seen that in OWC.

It sounds nice tho. It seems like Dimension Hierarchies are kindof
misleading on the Microsoft side-- I didn't really think that they did
_anything_ special-- but if cognos can read them like that; then I say that
we just hound Microsoft until they give it to us.

-aaron


"Dragon" <Dragon (AT) discussions (DOT) microsoft.com> wrote

I think that you can use the AFTER argument in the descendents function
in order to do this.

Look it up in books online; it allows you to have

YEAR
QUARTER
MONTH

data all show up on different rows; instead of on different levels.

-Aaron Kempf
aaron_kempf (AT) hotmail (DOT) com
aaron.kempf (AT) gmail (DOT) com


aaron_kempf (AT) hotmail (DOT) com wrote: