dbTalk Databases Forums  

can't drillthrough if fact table is not at leaf level...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss can't drillthrough if fact table is not at leaf level... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default can't drillthrough if fact table is not at leaf level... - 09-25-2006 , 04:30 PM






Hi,

I have a cube where a measure group is NOT linked to the leaf level of my
time dimension.
I'm linked to the month level and not the day level for this particular
measure group.

but the result of this design produce a drill through error when I try to
drill through...
The system says there is a security error but in fact the server refuse to
execute the drill through.

all drill against the other measure group (linked at the day level) works
fine in the cubes.

does its a normal behavior?
a bug?
any workaround? (except linked to the day level or adding another measure
group)
or anything else?

thanks.

Jerome.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.