Monday, 13 June 2011

Filtering records using Named Set

The screen of the P&L report is as follows



As shown above there are four calculated columns. The scripts of those are as below



The dimension hierarchy is as follows









 As shown on the top of the blog, if actuals under Current Year Current Month is falling having value as null, and if those fields have values for other columns then those should not appear in the report. Below is the screen shot from my DEV environment where i am getting the doc numbers with values under Current Year Curent Month. This is what exactly i need, but in PROD there are more records which are having values for other calculated members and having null under Current Year Current Month. we need to avoid this using named set.