Single and double intervalmatch mixed

[amien]

I have let was this intervalmatch range (gl_account)

100 - 199

200 - 299

300 - 399

I need for the last category another intervallmatch, because these costs are placed

Under a certain cost place range.

Anothe issue is that some gl account are mixed. So are both in the 200-299 category and also gl account under the 300-399 (including the specific costplace)

How can this be fixed?

[amien]

Let was = lets say

[prieper]

Define a rule?

Peter

[amien]

What do you mean?

[amien]

Intervalmatch1 | intervalmatch2

------------------------------------

100...........199 |

200...........299 |

300...........399 | 9000....... 9050

300...........399 | 9060........9800

Interval1  = gl account

Intetval2.  = costplace

[prieper]

How should this work without duplicating the data?

Peter

[amien]

Where do you see duplication? 300-399 has an extra intervalmatch

[#8]

I don't see any IntervalMatch request in your post. I can see that you try to define accounts chart for your GL to describe your cost centers. Where and how are you going to use IntervalMatch functionality?

[amien]

fact_table:

Key, GL_Account, CostPlace, Value, Brand, .....

intervalmatch1:

LOAD * INLINE [

from, to, text

100 - 199, inventory

200 - 299, unknown

300 - 399, indirect costs

100 - 399, subtotal I

]

intervalmatch2:

LOAD * INLINE [

from, to ,text

9000, 9050, indirect costs - costplace I

9060, 9800, indirect costs - costplace II

9000, 9050, subtotal I

9060, 9800, subtotal I

];

INTERVALMATCH (GL_Account)

LOAD

    from,

    to

RESIDENT intervalmatch1;

INTERVALMATCH (CostPlace)

LOAD

    from,

    to

RESIDENT intervalmatch2;

[amien]

if could use alot of IF statements instead of intervalmatch . but than i have a problem with the subtotals as dimensions.

also tried to combine GL_account with costplace (1009000 - 1999050 or 9000100 - 905199) as a interval, but than i have an overlapping issue ofcourse.