Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;