Hi, Your case is "Fact not joining all dimensions" Refer the below link kpi partners: When Fact Tables Do Not Join to All Dimension Tables Thanks, JP

Hi, Can you give the full query generated from BI Server? Thanks, JP

Sreekanth, You can achieve using selection step. * Right-click a row at left most column (Op Code in ur case) * From the context menu choose the column name( Op Code) -> Remove -> Based on Custom Codition. In my case the column name is "Per Name Month" * Choose the condition for total "0" Thats it. You are done! Thanks, JP

Kavya, You can create the ago measure using the below link OBIEE 10G/11G - Period to period comparison with the AGO Function [Gerardnico] For ur case: AGO(<YOUR MEASURE>, <MONTH COL>, <1>) Note: You need to have Time Dimension defined in your business model Thanks, JP

Hi, You can achieve using OR in filters and make them "is prompted" Thanks, JP

Hi Abhilash, After editing from EM, * Apply * Activate Changes * Restart Presentation Services Presentation Services restart will do the change. Thanks, JP