Msolap And Mdx
Computer
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
MSOLAP Fundamentals
Dimension
Designing Cubes
Measures
MDX
|
|
||||||||||||
Msolap And Mdx
MSOLAP Fundamentals
Data Explosion
Sparsity
Dimension
Star viersus Snow
Shared or Provate
Changing Dimension
Virtual Dimension
Parent Child Dimension
Can parent child also be changing?
Dimension Hierarchies
Multiple Hierarchies for single dimension
Dimension Levels and Members
Member Keys
Member Properties
Designing Cubes
Linked Cubes
Virtual Cubes
Distributed Partition Cubes
Real Time Cubes
CACHING and Cubes
Cube Partitioning and Record size impact on performance of cubes
Partition Organization
Partition Processing
Aggregations
Write Back function
Measures
Distinct Counts
Calculated Cells
Actions
Named Sets
MDX
Overview and Concepts of MDX
Members
Tuples
Sets
Comparison of SQL syntax with MDX syntax
Different FUNCTIONS in MDX like EmptyCrossJoin, RollupChildren etc.
Axis and Slicer Dimensions and their use within an MDX query with SELECT and WHERE clauses
Establishing Cube context purpose of FROM clause
Creating and using Named sets, Calculated Cells, Calculated Members, Dimension Levels, Members and Cell properties
CACHE building in MDX queries
Pass Order and Solve Order
What is WRITE BACK?
WHERE clause overrides
Comments in MDX queries
What are external function libraries? How can we create our own function libraries? How to use Excel and VB libraries in MDX.
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
