×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Hide members of snowflake/parentchild dimension when null

Hide members of snowflake/parentchild dimension when null

Hide members of snowflake/parentchild dimension when null

(OP)
Hello, I have a cube wich has two dimensions, One is the  "Concept" (star schema) dimension, this one is linked to a "Department"(parent-child schema) dimension.

So, when I browse the data I wish to see something like this:
  -Department1
     -Sub department 1
        Concept 1
        Concept 2
        Concept 3
     -Sub department 2
        Concept 4
   -Department 2
      -Sub department 2
         Concept 5

and so on.. I know this looks exactly like only one parent-child dimension, but i need to simulate this behavior having two dimensions, the departments dimension (parent child) and the concepts dimension (star schema, but linked to the lowest level of the deparment dimension).

So, somebody can help?
odin.dark@gmail.com
thanks in advance!
      

RE: Hide members of snowflake/parentchild dimension when null

(OP)
I forgot to say, using the schema above, when I drop the dimension departments and then drop the dimension concepts, all concepts are shown in each level on the departments, and I want only the ones that are linked to it

RE: Hide members of snowflake/parentchild dimension when null

What Cube engine are you using as this can effect the answer.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: Hide members of snowflake/parentchild dimension when null

(OP)
I'm using Analysis services from Microsoft. thanks in advance!

RE: Hide members of snowflake/parentchild dimension when null

I would build a view that lines the dataup in manner to support you dimension and create the dimension based from the view.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close