Re: AS: Only show dimension values that corresponds to fact table

#1

Hi,

This is possible. Even it is possible to show only related dimensions
after choosen a dimension.

We are using Panorama 4.0 as frontend where a standard feature is to
show only slicer info if values are not null. That is all you need.

On our website you will find more info and tips: www.gmsbv.nl

Regards,
Marco

"Henrik Hjøllund" <hjoellund (AT) mail (DOT) tele.dk> wrote

Quote:

Hi

Is there a way to only show the dimensions values that have corresponding
values in the fact table.

Say I have a fact table like

Productid number
1 10
2 11
3 14

and a dim table like
ProductGroup productid
1 1
1 2
1 3
1 4
2 5
3 6

when I build the cube I get ä cube with all the dim values but some of then
with null values. What had happen is a left join between the dim table and
the fact table. Is there a way to only get the dim values that have
corresponding values in the fact table, like an inner join in the resulting
cube.

Thanks in advance
-Henrik

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

Re: AS: Only show dimension values that corresponds to fact table

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

Re: AS: Only show dimension values that corresponds to fact table - 06-05-2004 , 02:56 AM