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?

[#2]

see attachment

[amien]

Thanks .. i will look into it first thing tomorrow ..

whats the purpose of this?

Left Join (fact_table)

LOAD

    *

RESIDENT intervalmatch1;

[#4]

Amien wrote:

Thanks .. i will look into it first thing tomorrow ..

whats the purpose of this?

Left Join (fact_table)

LOAD

    *

RESIDENT intervalmatch1;

to deliver "text" fields to fact_table records.

[amien]

Nick,

* interval2 needs to be based on both glaccount number and costplace.

* text1 and text2 should be 1 dimension, not 2

So, this row:

4, 301,9070, 3425, DDDD

is indirect costs because 301 falls into 300-399 PLUS the costplace falls into the 9060-9800 range.

1, 101,9040, 1000, AAA

does not fall into the indirects costs because 9040 falls into the 9000-9050 range, but GL_account is 101 and does not fall into the 300-399 range.

in the end i need 1 dimension in the chart (text1 for the GL accounts only category and text 2 for the costplaces). Mind that some categories are a mix from both GL accounts only values and GL accounts and costplaces values. Plus there are subtotals.

shoot when you need more information

[amien · Accepted solution]

this fixed my issue

IF(GLAccount > 300000 and < 399999,Costplace,GLAccount) AS GL_Account2;

now i only need 1 intervalmatch, plus i can create subtotals in the intervalmatch, without creating too much lines

[#7]

Amien wrote:

this fixed my issue

IF(GLAccount > 300000 and < 399999,Costplace,GLAccount) AS GL_Account2;

now i only need 1 intervalmatch, plus i can create subtotals in the intervalmatch, without creating too much lines

We are not telepathists to read your mind for application logic. It's up to you. But this is definitely not the answer for the topic of the post.