INTERVALMATCH

[#1]

Hi -

Can someone please help me with figuring out INTERVALMATCH issue that i am having when running QV script ( i am new to QV)

Step 1. I am using MDX statement to get Account infromaiton:

               Temp Table:

                         SELECT

                           { null } on 0,

                                 {DESCENDANTS([Account])}on 1   

                                   FROM [Cube];

Step 2. AND then i need to run intervalmatch formula that looks like this

               IntervalMatchTemp:

               INTERVALMATCH [Account] LOAD [GL Account Start], [GL Account End] RESIDENT Layout;

SCRIPT ERROR

Field is not Found

IntervalMatchTemp:

INTERVALMATCH {[([Account])} LOAD [GL Account Start], [GL Account End] RESIDENT Layout

Please help!

Thank you

[#2]

Hi,

Could you write " exit script " after the loading of PLTemp and then, take a screenshot of the Table Viewer in order to see what is the name of your field after the load ?

Amand Dupretz

[#3]

Start and End date are part of a different query. Which is work

PLTemp:

SELECT

  { null } on 0,

        ([Account].[H1].[LEV14])on 1

FROM [Cube];

IntervalMatchTemp:

INTERVALMATCH ("[Account].[H1].[LEV14]") LOAD [GL Account Start], [GL Account End] RESIDENT Layout;

IntervalMatch:

Load

distinct

("[Account].[H1].[LEV14]"),

[GL Account Start] & '|' & [GL Account End] as GLStartEnd

resident

IntervalMatchTemp;

drop table IntervalMatchTemp;

Drop table PLTemp;

Drop fields [GL Account Start], [GL Account End] from IntervalMatch;