When there is a complex formula in a cube and when a local cube is made out of it.The member doe not come.if a calculated member is made from another calculated member then that calculated member doe not simply show up
belpw is a sample calculated member that does not show up
((((([Measures].[Allowed Amount Rx Cmpl],[Incurred YTD].[All Incurred YTD].LastChild) /([Measures].[Member Months Elig Rx],[Incurred YTD].[All Incurred YTD].LastChild))*12)) -
(([Measures].[Allowed Amount Rx Cmpl],[Incurred YTD].[All Incurred YTD].LastChild.Lag(1))
/([Measures].[Member Months Elig Rx],[Incurred YTD].[All Incurred YTD].LastChild.Lag(1))*12))
(((([Measures].[Net Payments Rx Cmpl],[Incurred YTD].[All Incurred YTD].LastChild.Lag(1))/([Measures].[Employee Months Elig Rx],[Incurred YTD].[All Incurred YTD].LastChild.Lag(1))*12)) /
((([Measures].[Allowed Amount Rx Cmpl],[Incurred YTD].[All Incurred YTD].LastChild.Lag(1))/([Measures].[Employee Months Elig Rx],[Incurred YTD].[All Incurred YTD].LastChild.Lag(1))*12)))
(([Measures].[Member Months Elig Rx],[Incurred YTD].[All Incurred YTD].LastChild)/([Measures].[Employee Months Elig Rx],[Incurred YTD].[All Incurred YTD].LastChild))