Versions Compared

Old Version 1

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • AddCalculatedMembers 

  • AllMembers 

  • Ancestors 

  • Ascendants 

  • BottomCount 

  • Children 

  • Crossjoin 

  • Descendants 

  • Distinct 

  • DrilldownLevel 

  • DrilldownLevelTop 

  • DrilldownLevelBottom 

  • DrilldownMember 

  • DrilldownMemberTop 

  • DrilldownMemberBottom 

  • Except 

  • Exist 

  • Extract 

  • Filter 

  • Generate 

  • Head 

  • Hierarchize 

  • Identify_Member(Customized) 

  • IIF 

  • Intersect 

  • Members 

  • NonEmpty 

  • NonEmptyCrossjoin 

  • Order 

  • PeriodsToDate 

  • Range 

  • Siblings 

  • StripCalculatedMembers 

  • Subset 

  • Tail 

  • TopPercent 

  • BottomPercent 

  • TopSum 

  • BottomSum 

  • TopCount 

  • Union 

Scalar functions 

  • XIRR

  • Aggregate – SUM, AVG, MIN, MAX 

  • CASE 

  • Count 

  • CurrentOrdinal 

  • Date 

  • Month 

  • Format 

  • Mathematical Operators- 

  • POWER,SQRT,ROUND,ROUNDUP,ROUNDDOWN,ABS 

  • Now() 

  • YEAR 

  • MONTH 

  • GETTIMESTAMP(customized) 

  • GETDATE(customized) 

  • Member Properties - Caption, Name, Uniquename, Level_number 

  • member_value,member_key 

  • Rank 

  • Level Properties - Name, Caption , level_number, UniqueName 

  • String Utility Operations - Left, Right, Instr, Len, Ltrim, Rtrim 

  • AllValue(customized) 

  • Case Logical 

  • ISUDA 

...