Strategy One
Import Measures as Regular Dimensions
- Open a new or existing dashboard.
 - 
                                                    
Click Add Data
  and choose New Data. - Click OLAP.
 - Choose an Essbase connection.
 - Select Import hierarchy as hierarchical attribute.
 - Click More Import options.
 - Select Import measure as a regular dimension. If you import the MDX cube without this option, you must remove the MDX cube and import it again.
 
                                                    
                                                
                                                    
                                                
                                                    
                                                
