dbTalk Databases Forums  

none aggregating measures in 2005 beta3

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


Discuss none aggregating measures in 2005 beta3 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joos
 
Posts: n/a

Default none aggregating measures in 2005 beta3 - 06-16-2005 , 11:48 AM






How do none aggregating measures behave? I have added one into a cube.
Processing is fine, but I do not see any values in the cube browser! Any idea?
Should it be possible to load values on non leaf members for a none
aggregating measure?

Reply With Quote
  #2  
Old   
Thierry
 
Posts: n/a

Default Re: none aggregating measures in 2005 beta3 - 06-17-2005 , 02:36 PM






NONE means it doesn't aggregate anything, so unless you are at the very leaf
of every attribute hierarch, user hierarchy of every single dimension, yuo
won't see anything, which is the correct behavior....

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

Quote:
How do none aggregating measures behave? I have added one into a cube.
Processing is fine, but I do not see any values in the cube browser! Any
idea?
Should it be possible to load values on non leaf members for a none
aggregating measure?



Reply With Quote
  #3  
Old   
Joos
 
Posts: n/a

Default Re: none aggregating measures in 2005 beta3 - 06-20-2005 , 01:48 AM



Thank you for your answer!

However, a more logic behaviour would be that you are able then to load
values on higher levels within dimensions. Is there any way to achieve this?

"Thierry" wrote:

Quote:
NONE means it doesn't aggregate anything, so unless you are at the very leaf
of every attribute hierarch, user hierarchy of every single dimension, yuo
won't see anything, which is the correct behavior....

Thierry
"Joos" <Joos (AT) discussions (DOT) microsoft.com> wrote in message
news:3A7FB0E9-1494-456D-A225-6293A32F8E75 (AT) microsoft (DOT) com...
How do none aggregating measures behave? I have added one into a cube.
Processing is fine, but I do not see any values in the cube browser! Any
idea?
Should it be possible to load values on non leaf members for a none
aggregating measure?




Reply With Quote
  #4  
Old   
Thierry
 
Posts: n/a

Default Re: none aggregating measures in 2005 beta3 - 06-24-2005 , 02:29 PM



There is ways to achieve this in AS2005.

Look for the loading aggregate data paper on:
http://www.sqlserveranalysisservices.com/default.htm

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

Quote:
Thank you for your answer!

However, a more logic behaviour would be that you are able then to load
values on higher levels within dimensions. Is there any way to achieve
this?

"Thierry" wrote:

NONE means it doesn't aggregate anything, so unless you are at the very
leaf
of every attribute hierarch, user hierarchy of every single dimension,
yuo
won't see anything, which is the correct behavior....

Thierry
"Joos" <Joos (AT) discussions (DOT) microsoft.com> wrote in message
news:3A7FB0E9-1494-456D-A225-6293A32F8E75 (AT) microsoft (DOT) com...
How do none aggregating measures behave? I have added one into a cube.
Processing is fine, but I do not see any values in the cube browser!
Any
idea?
Should it be possible to load values on non leaf members for a none
aggregating measure?






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.