Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limiting to descendants to specfic ancestor

957239Aug 29 2012 — edited Sep 5 2012

How can I limit a dimension to obtain specific descendants of of a hierarchy?

Example:

YEAR
QTR
MONTH
DAY

I'd like to obtain all days for Year X.

Or

CATEGORY
SUBCATEGORY
PRODUCT

I'd like to obtain all products for a specific Category or Subcategory.

Another example could be.

If you have

MONTH
DAY

How can I determine all previous days (in that month) compared to the current day

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2012

Added on Aug 29 2012

#data-warehousing, #olap

2 comments

166 views