Dynamic Filter depends on dependent dimensions in EPM Report

Hello,

I come across a case like suppose there are 2 dimension which are dependent say ENTITY and PRODUCT, and both the dimensions are going to be take in column axis and ACCOUNT dimension in row axis in the report.

Here is the issue like for each entity there are restricted number of products lets say C1000 has 3 products, C2000 has 5 products, C3000 has 4 products and so on. I need to display only these products when we select specific entity in the report dynamically.

I tried in couple of ways but i couldn't make it. Any suggestions to make this to be done.

Thanks in Advance,

Siva Nagaraju