Question on measure groups

#1

Hi,

I have two fact tables in a cube, one at Product level and other at Product
Family level. With measure groups , created a cube with multip fact tables.

When i browse the data at Product Level, the measure from the second fact
tables are coming with the total aggregated value. Is there any way to stop
this value and show 'N/A' (not applicable) something like this? the reason i
want to show like this is second fact measures are at diff level.

Any pointers are really appreciated.

Thanks in advance
Bhaskar

#2

you can create a scope calculation
something like:

scope(product.product level.members, measures.[measure1]);
this='N/A';
end scope();

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

Quote:

Hi,

I have two fact tables in a cube, one at Product level and other at
Product
Family level. With measure groups , created a cube with multip fact
tables.

When i browse the data at Product Level, the measure from the second fact
tables are coming with the total aggregated value. Is there any way to
stop
this value and show 'N/A' (not applicable) something like this? the reason
i
want to show like this is second fact measures are at diff level.

Any pointers are really appreciated.

Thanks in advance
Bhaskar

#3

Hi Jeje,
Can you pls point to me for some technical links where i can get more
information on scope cacculations.

Thanks
Bhaskar

"JÃ©jÃ©" wrote:

Quote:

you can create a scope calculation
something like:

scope(product.product level.members, measures.[measure1]);
this='N/A';
end scope();

"Bhaskar" <Bhaskar (AT) discussions (DOT) microsoft.com> wrote in message
news:9059DA17-6758-485F-BB49-AEA6B8121B63 (AT) microsoft (DOT) com...
Hi,

I have two fact tables in a cube, one at Product level and other at
Product
Family level. With measure groups , created a cube with multip fact
tables.

When i browse the data at Product Level, the measure from the second fact
tables are coming with the total aggregated value. Is there any way to
stop
this value and show 'N/A' (not applicable) something like this? the reason
i
want to show like this is second fact measures are at diff level.

Any pointers are really appreciated.

Thanks in advance
Bhaskar

#4

download the zip file from this page:
http://sqljunkies.com/WebLog/mosha/a...2/16/7852.aspx

other resources:
http://www.mosha.com/msolap/yukon.htm

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

Quote:

Hi Jeje,
Can you pls point to me for some technical links where i can get more
information on scope cacculations.

Thanks
Bhaskar

"Jéjé" wrote:

you can create a scope calculation
something like:

scope(product.product level.members, measures.[measure1]);
this='N/A';
end scope();

"Bhaskar" <Bhaskar (AT) discussions (DOT) microsoft.com> wrote in message
news:9059DA17-6758-485F-BB49-AEA6B8121B63 (AT) microsoft (DOT) com...
Hi,

I have two fact tables in a cube, one at Product level and other at
Product
Family level. With measure groups , created a cube with multip fact
tables.

When i browse the data at Product Level, the measure from the second
fact
tables are coming with the total aggregated value. Is there any way to
stop
this value and show 'N/A' (not applicable) something like this? the
reason
i
want to show like this is second fact measures are at diff level.

Any pointers are really appreciated.

Thanks in advance
Bhaskar

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Question on measure groups

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

Question on measure groups - 07-28-2006 , 08:53 AM

Re: Question on measure groups - 07-28-2006 , 09:41 AM

Re: Question on measure groups - 07-28-2006 , 11:58 PM

Re: Question on measure groups - 07-29-2006 , 08:38 AM