experts of Analysisview,pls give answer to this

[shivareddyk]

pls see the code,

 

(optional question?

weather i-reports supports those many levels with blank cells any one of level?)

Regards

Code:

 Hi ,select NON EMPTY {[Measures].[balance], [Measures].[Peso Equiv]} ON COLUMNS,  NON EMPTY Hierarchize(Union(Union(Union({[PARTICULARS].[All Particulars], [PARTICULARS].[All Particulars].[RESIDENTS], [PARTICULARS].[All Particulars].[NON-RESIDENTS], [PARTICULARS].[All Particulars].[NON-RESIDENTS].[NON RESIDENT OTHERS], [PARTICULARS].[All Particulars].[NON-RESIDENTS].[NR OTHER BANKS], [PARTICULARS].[All Particulars].[NON-RESIDENTS].[NR CORPORATIONS]}, [PARTICULARS].[All Particulars].[NON-RESIDENTS].[NON RESIDENT OTHERS].Children), [PARTICULARS].[All Particulars].[RESIDENTS].Children), [PARTICULARS].[All Particulars].[RESIDENTS].[GOVERNMENT].Children)) ON ROWSfrom [depositlib_22]where [REPORT DATE].[All Report Date]----------------------------------|                                                                                                     | Balance          | Peso Equiv         |+-----------------+---------------+-----------------------------------+-------------------------------+------------------+--------------------+| All Particulars |               |                                   |                               | 8,286,706,398.76 | 373,066,873,125.05 ||                 | RESIDENTS     |                                   |                               | 8,279,166,150.24 | 373,059,101,772.19 ||                 |               | GOVERNMENT                        |                               |            68.38 |              68.38 ||                 |               |                                   | NATIONAL GOVERNMENT           |             0.00 |               0.00 ||                 |               |                                   | LOCAL GOVERNMENT UNITS (LGUS) |            68.38 |              68.38 ||                 |               | BANKS                             |                               |        20,016.00 |          20,016.00 ||                 |               | PRIVATE CORPORATIONS              |                               | 2,333,833,552.00 | 105,285,203,555.12 ||                 |               | INDIVIDUALS                       |                               | 5,868,811,051.04 | 265,546,669,715.44 ||                 |               | TRUST DEPARTMENT                  |                               |         5,149.25 |           5,149.25 ||                 |               | DEVELOPMENT LOAN INCENTIVES       |                               |     8,814,108.10 |     513,672,968.25 ||                 |               | SMALL AND MEDIUM ENTERPRISE LOANS |                               |     2,387,297.55 |      88,637,297.55 ||                 |               | INDIVIDUAL,PARTNERSHIP, ASSOCI    |                               |    65,294,907.92 |   1,624,893,002.20 ||                 | NON-RESIDENTS |                                   |                               |     7,540,248.52 |       7,771,352.86 ||                 |               | NON RESIDENT OTHERS               |                               |         2,000.00 |           2,000.00 ||                 |               | NR OTHER BANKS                    |                               |     7,316,971.80 |       7,316,971.80 ||                 |               | NR CORPORATIONS                   |                               |       221,276.72 |         452,381.06 |After i run the above mdx ,i got the above table as a result set.under NON-RESIDENTS we have multiful types(NON RESIDENT OTHERS ,NR OTHER BANKS ...).u can assume All Particulars data column as Level1, RESIDENTS  data column as Level2,GOVERNMENT data column as Level3,NATIONAL GOVERNMENT  data column as Level4.Level4 column all Members are blank(Except Level3 GOVERNMENT types in Level4).Question???I need to dispaly, Level4 All blank Members as NULL(Except Level3 GOVERNMENT types in Level4).how we can change The aove MDX?

[shivareddyk]

any idea to fix the above issue?