How to limit rule area?

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • How to limit rule area?

      Problem description:

      Cube 'Helper' (contain info about what Group learn what Discipline (cells contains 1/0 = yes/no):
      - Discipline (Math, ..., Total)
      - Student Group (101, 102, ... Total)
      - Semester (1,2, Total)

      Cube 'Main' (contain info about how many students learn Discipline):
      - Discipline (Math, ..., Total)
      - Student Group (101, 102, ... Total)
      - Semester (1,2, Total)
      - Measure (Student Number) - calculated by rules

      Real number of student is located in Attribute of 'Student Group' dimension.

      Rule#1:
      ['Number Of Students'] = C:IF(PALO.DATA("DB","Helper",!'Discipline',!'Student Group',!'Semester') > 0,PALO.DATA("DB","#_Student Group","Number Of Students",!'Student Group'),0)

      Rule#2:
      ['Number Of Students'] = N:IF(PALO.DATA("DB","Helper",!'Discipline',!'Student Group',!'Semester') > 0,PALO.DATA("DB","#_Student Group","Number Of Students",!'Student Group'),0)

      I want that Rule#1's area don't include aggregative elements of 'Student Group' dimension. Is it possible?

      Attachments: palo db files, .xls files.

      Thanks a lot!
    • RE: How to limit rule area?

      Hi, Giperion,

      Try it instead of your Rule#1:

      ['Number Of Students'] = C:IF(PALO.ELEVEL("DB","Student Group",!'Student Group') > 0,STET(),IF(PALO.DATA("DB","Helper",!'Discipline',!'Student Group',!'Semester') > 0,PALO.DATA("DB","#_Student Group","Number Of Students",!'Student Group'),0))

      Remarks: Number of students can be dynamic therefore would be better to keep it in a/the cube
      regards,

      Attila
    • RE: How to limit rule area?

      Group. Number Of Students
      Total.. 112,00
      101.... 15,00
      102.... 20,00
      103.... 30,00
      104.... 25,00
      105.... 22,00

      Maximum Number Of Students - 112. It's impossible that 185 students study disciplines (at least one) in 1st or 2nd semester or whole year. It is heart of the problem.