Hi,

I am explaining my problem with following example.
I want to Create a Report which show my All Station (Dimension) and display
its Total Test Performed on this Station (Measure)

Station Name Total Test Performed
========= ==============
Station A 0
Station B 500
Station C 50
.... ...

I have one Station Table which have all station information and one Test
Table which include StationId and Test Information.

In above case If I take Station Table As Dimension then Station A is not
display because Test does no have any record with this Station. In this case
I want to display Station A also.

when i process with this it giving me following error:
Error Messages 2
Errors in the OLAP storage engine: The attribute key cannot be found: Table:
DimStation, Column: StationID, Value: Station A. Errors in the OLAP storage
engine: The record was skipped because the attribute key was not found.
Attribute: Dim Station of Dimension: Dim Station from Database: SLC OLAP
Database, Cube: Test, Measure Group: Fact Tests, Partition: Fact Tests,
Record: 1.

that is why I am Creating Station Dimension from Station Table and want to
Map with with Test Table.
I want to display Station A anyhow. can you please tell me how to solve this
problem.

Dinesh Patel