No rows showing the CUBE Browser

Question

Hi All,
I have a strange thing happening with my CUBE. The FACT table In the data source view is from the SQL Server , It has TRANSACTION KEY and TRANSACTION AMOUNT. I created a new named SQL Query in the data source view

SELECT DISTINCT TRANSACTIONKEY
FROM FACTTABLE

I created a new dimension TRANSACTION KEY based on this table. I created a relationship between this table and the FACT based on the TRANSACTIONKEY. I also created a cube dimension based off this TRANSACTIONKEY Dimension and DIMENSION USAGE based on the TRANSACTIONKEY. I processed both the dimension and cube.
When i drag the transcationkey and Amount I do not see any rows but i see the value in the data source

SELECT *
FROM FACTTABLE
WHERE TRANSACTIONKEY=496538314

I checked all the relationships and I do not see any issue. Please advice.
Thanks

Answer 1

With setup this simple, the culprit is probably also simple, typo-class. Start by checking that the Amount measure returns data when not sliced by the dimension and that the dimension contains members including the one you've chosen for your example.