Smart view Training

Smart view Training Introduction:

Smart View training provides you A Microsoft Office add-in that provides an access to CalPlanning data through either the CalPlan, CalRptg, HCP &  HCPRptg databases from within the Microsoft Office Excel, Word, and  PowerPoint. The smart view  by Example series reduces the time spent investigating what are steps are required to perform the  task. Because the step-by-step solutions are to be built for the practical for real world situations, not only the knowledge is  gained through valuable hands-on experience, but also the solutions presented may  be used as the foundation for production implementation, dramatically reducing time to the  deployment. Experience an exciting and innovative Accelerated Learning  at Global Online Training . We introduces some of the principles of the accelerated learning & explores techniques for you to try out with in  your pupils. Accelerated learning  is suitable for those new to an  concepts & also  those wanting to brush up on the existing knowledge.After completion of this  training, one should be able to  change ways of practise  to use these techniques. For more details about this course register with us, or call our help desk now!

Smart view Online Training Course Content

Introduction to the Smart View
  • Multi-Dimensional Analysis Overview
  • Smart View Architecture
  • Smart View Excel User Interface
  • Connecting to the Data Sources
Creating the Ad Hoc Analysis Reports
  • Creating the Ad Hoc Grids
  • Performing Ad Hoc Operations in Multiple Cells
  • Creating the Member Selections
  • Associating Data Sources with Worksheets
  • Creating Multiple Grids on One Worksheet
  • Creating the Free-form Grids
  • Working with the Essbase Ribbon
  • • Working with Document Contents Pane
Setting Smart View Options
  • Setting Global & Sheet-Level Options
  • Setting Data Navigation & Retrieval Options
  • Setting Number & Cell Formatting Options
  • Setting Administrative Options
  •  Displaying Aliases for Member Names
Creating the Advanced Reports
  • Creating the Queries using Query Designer
  • Creating a Smart Query
  • Creating Reports using Functions
  • Executing MDX Queries
  • Retrieving Data for the DTS Members
  • Retrieving Data for the Attribute Dimensions
  • Working with the Excel Formulas
  • Replacing Data with the Numeric Zeroes or Text
Working with the Smart Slices

• Creating the Reports with Smart Slices