Hi All,

I have two tables as under

TableA which has primary key column as PK1.

TableB has a column refering to the column PK1 of TableA. The TableB can
have NULL Values. I am building a cube with TableA's primary key column as
dimension and one of the fields of TableB as measure. When the cube is
processed, I am unable to see those records for which TableB columns have
NULL Values.

In crux, the question is; how do I display records for which I have NULL
Values?

NOTE: I did get when I used views, but I want to get the same result WITHOUT
USING VIEWS.

Thanks in advance
Nagesh