# 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,

['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?

One question. What is STET()?
• STET() do nothing

useful to switch off rules for certain slices of your cube

e.g. if you want to prevent seeking for previous element for the first element
• Unfortunately it's not as would like it to be.

When I limited rule with PALO.ELEVEL() I see this result (see screen).
• # RE: How to limit rule area?

The 90 students for semester 1: (Are) Were they really existing or hypothetical? You only have the number of students for semester 2 as source data.

As olapboy already mentioned, you should take history into account.
• # 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.