Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-06-13 02:42 AM

blocking the use of invalid dimensions

Hi,

I have setup a demo warehouse with two fact tables: SALES and BONUS. BONUS is linked through a link table to the dimensions YEAR and EMPLOYEE. SALES is also linked to YEAR and EMPLOYEE through the same link table, but also has non confomed dimensions such as PRODUCT and CUSTOMER. When I request the BONUS amount per CUSTOMER I get rubbish of course, because CUSTOMER isn't directly connected to BONUS.

Is it possible to exclude the selection of invalid dimensions somehow in QV?

regards, Jeroen

2,435 Views
0 Likes
0 Replies