How to create a measure by attaching query to it

#1

As I know, I can create a measure only from columns in fact table. But how do I create a measure by writing a query which brings data from other tables ( other than fact table) as well.

#2

Probably the best approach is to use a view to source your cube.

public @ the domain below
www.tomchester.net

"Tushar" <tbolinjkar (AT) saba (DOT) com> wrote

Quote:

As I know, I can create a measure only from columns in fact table. But how
do I create a measure by writing a query which brings data from other tables

( other than fact table) as well.

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

How to create a measure by attaching query to it

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

How to create a measure by attaching query to it - 01-06-2004 , 08:56 AM

Re: How to create a measure by attaching query to it - 01-06-2004 , 10:13 AM