ITPub博客

首页 > 数据库 > Oracle > HP 规则常用函数总结

HP 规则常用函数总结

原创 Oracle 作者:chenshm329 时间:2017-02-23 16:46:44 0 删除 编辑
1. FIX

2.@IDESCENDANTS:返回自身及所有的后代(Return the specified member and either all descendants of the member or all descendants down to the specified generation or level)
Syntx: @IDESCENDANTS(mbrName[,genLevnum | genLevName])
eg:@IDESCENDANTS(100) 返回 100,100-10,100-20,100-30

3.@DESCENDANTS:返回所有的后代(Return  either all descendants of the member or all descendants down to the specified generation or level)
Syntx: @DESCENDANTS(mbrName[,genLevnum | genLevName])
eg:@DESCENDANTS(100) 返回 100-10,100-20,100-30
 
4.@RELATIVE:Returns all members at the specified generation or level that are above or below the specified member in the database outline.
Syntx: @RELATIVE(mbrName[,genLevnum | genLevName]) , positive integer defines a geneartion number.A value 0 or a negative integer defines a level number;
eg:@RELATIVE(Qtr1,3) 返回 Jan, Feb, Mar; @RELATIVE(Qtr1,0) 返回 Jan, Feb, Mar

5.@IALLANCESTORS:Returns the specified member an dall the ancestors of that member, including ancestors of any occurrences of the specified member as a shared member;
Syntx: @IALLANCESTORS(mbrName)
eg: 100
         100-10 ,100-20,
      Diet
         100-20
      @IALLANCESTORS(100-20) 返回 100-20,100,Diet

6.@XREF
      跨库取数: Enables a database calculation to incorporate values from another Essbase database;
      Syntax: Data target: the database on which the current calculation is running(that is, the database on which the @XREF call originates); location alias(eas 中,如_PnlCube)
                 Data source: the database that is queried by the @XREF function. This database may be remote(that is , on a different machine than the data target).
                 POV: the member combination currently being calculated on the data target(that is , the member combination that identifies the left hand side of a calculation).
          @XREF(locationAlias [,mbrList])
      Notes: (1) An error is returned if the members supplied in mbrList do not exist in the data source.
                (2) The number of data cells queried on the data source must match the number of data cells expected on the data target.
                (3) The member list cannot contain functions that return more than one member. For example, the following formula is not valid:
                       West = @XREF(SourceDb, @LEBMBRS(Market,0));
                (4)The member list can't contain ranges. For example, the following formula is not valid:West = @XREF(SourceDb, Jan:Mar);
               (5) mbrList can contain attribute members . For example, the following formula is not valid:RedThings= @XREF(SourceDb, Sales, Red);

7.@SUMRANGE: Returns the summation of all the values of the specified member(mbrName) across the specified range(XrangList).
   Syntax: @SUMRANGE(mbrNmae [,XrangeList])
   eg: Fix(Sales)
           "Partial Year' = @SUMRANGE("New York", Jan:Jun)
         EndFix

8.@CURRMBRRANGE
   Syntax:
  


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17087603/viewspace-2134175/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-09

  • 博文量
    182
  • 访问量
    173704