Asd

Wednesday, March 30, 2011

Inserting data from one table to another table In Sql Server.



Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2

Tuesday, March 29, 2011

IsAggregatable property of Dimension Attributes.

If the IsAggregatable property is set to True, an (All) level will exist. A hierarchy has no (All) level if the IsAggregatable property is set to False.

The presence of an (All) level in an attribute hierarchy depends on the IsAggregatable property setting for the attribute and the presence of an (All) level in a user-defined hierarchy depends on the IsAggregatable property of the attribute at the top-most level of user-defined hierarchy.

Note -  also that setting it to false means that the default member, if not defined, will be the first member in the list of members for that attribute. As such, any query will "Exists" any hierarchy selection from that dimension with a member from that attribute when the attribute is not queried explicitly.

 
Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2

Monday, March 28, 2011

Types of MDX Functions available in MDX Queries.


Different type of Category as below


1.       MDX KPI Functions
2.       MDX Metadata Functions
3.       MDX Navigation Functions
4.       MDX Other Functions
5.       MDX Set Functions
6.       MDX Statistical Functions
7.       MDX String Functions
8.       MDX SubCube Functions
9.       MDX Time Functions
10.   MDX UI Functions
11.   MDX Value Functions

1-MDX KPI Functions

             KPICurrentTimeMember 
             KPIGoal 
             KPIStatus 
             KPITrend 
             KPIValue 
             KPIWeight 

2-MDX Metadata Functions

             Axis 
             Count (Dimension) 
             Count (Hierarchy Levels) 
             Count (Tuple) 
             Hierarchy 
             Level 
             Levels 
             Name 
             Ordinal 
             UniqueName 

3-MDX Navigation Functions

             Ancestor 
             Ancestors 
             Ascendants 
             Children 
             Cousin 
             Current 
             CurrentMember 
             CurrentOrdinal 
             DataMember 
             DefaultMember 
             FirstChild 
             FirstSibling 
             IsAncestor 
             IsGeneration 
             IsLeaf 
             IsSibling 
             Lag 
             LastChild 
             LastSibling 
             Lead 
             LinkMember 
             LookupCube 
             NextMember 
             Parent 
             PrevMember 
             Properties 
             Siblings 
             UnknownMember

4-MDX Other Functions

             CalculationCurrentPass 
             CalculationPassValue 
             CustomData 
             Dimension 
             Dimensions 
             Error 
             Item (Member) 
             Item (Set) 
             Members (String) 
             Predict 
             SetToArray 

5-MDX Set Functions

             AddCalculatedMembers 
             AllMembers 
             BottomCount 
             BottomPercent 
             BottomSum 
             Crossjoin 
             Descendants 
             Distinct 
             Except 
             Exists 
             Extract 
             Filter 
             Generate 
             Head 
             Hierarchize 
             Intersect 
             MeasureGroupMeasures 
             Members (Set) 
             NonEmpty 
             NonEmptyCrossjoin 
             Order 
             StripCalculatedMembers 
             Subset 
             Tail 
             TopCount 
             TopPercent 
             TopSum 
             Union 
             Unorder    

6-MDX Statistical Functions

             Aggregate 
             Avg 
             CoalesceEmpty 
             Correlation 
             Count (Set) 
             Covariance 
             CovarianceN 
             DistinctCount 
             LinRegIntercept 
             LinRegPoint 
             LinRegR2 
             LinRegSlope 
             LinRegVariance 
             Max 
             Median 
             Min 
             Rank 
             RollupChildren 
             Stdev 
             StdevP 
             Sum 
             Var 
             VarP 
             VisualTotals 

7-MDX String Functions

             MemberToStr 
             NameToSet 
             Root 
             SetToStr 
             StrToMember 
             StrToSet 
             StrToTuple 
             StrToValue 
             TupleToStr 
             UserName 

8-MDX SubCube Functions

             Leaves 
             This 

9-MDX Time Functions

             ClosingPeriod 
             LastPeriods 
             Mtd 
             OpeningPeriod 
             ParallelPeriod 
             PeriodsToDate 
             Qtd 
             Wtd 
             Ytd 
            
10-MDX UI Functions

             DrilldownLevel 
             DrilldownLevelBottom 
             DrilldownLevelTop 
             DrilldownMember 
             DrilldownMemberBottom 
             DrilldownMemberTop 
             DrillupLevel 
             DrillupMember 
             ToggleDrillState 
            
11-MDX Value Functions

             IIf 
             IsEmpty 
             MemberValue 
             ValidMeasure 
             Value 

 
Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2