Hi,

I'm currently exploring the possibilities of microsoft BI, and am following some very rough training material.

I've imported some external tables and created my dimension and fact tables.

Now, the documentation tells me to fill the Dimensions and Fact Tables with SQL Queries. This seems all wrong to me. I have a background in Business OBjects and Oracle. And I always want to do all my loading and transformations in the tool. I'm messing around with it at the moment and have 2 questions really;

QUESTION A: I seem to be missing a basic 'Filter' option in the Package editer. I've found the source tables and now only want to import stuff that has 'Active = 'YES'. What functions as such a basic filter?'.

 QUESTION B: For my test I'm using 2 identical source tables. Now, I want to Union All TableA and TableB, and I want to store the Distinct  Variable1, Variable2.

It all should result in the ResultDimensionTable (KeyVariable, Var1, Var2).

What components should I use to get my proper results for question B?

Thanks!