HI,
Try this.
tmpSOE:
LOAD
filepath() as FileName,
SheetId as ObjectId,
'Sheet' as SOE_Type,
Title as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Sheet]);
// Sheet Objects
OUTER JOIN LOAD
filepath() as FileName,
REPLACE(ObjectId,'Document\','') as ObjectId,
Type as SOE_Type,
Caption as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/SheetObject]);
//Expressions:
OUTER JOIN LOAD
filepath() as FileName,
ObjectId,
'Expression' as SOE_Type,
Definition,
Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Expression]);
//CalculatedDimension:
OUTER JOIN LOAD
filepath() as FileName,
ObjectId,
'Dimension' as SOE_Type,
PseudoDef as Definition,
Title as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Dimension]);
//VariableDescription:
OUTER JOIN LOAD
filepath() as FileName,
ObjectId,
'Variable' as SOE_Type,
RawValue as Definition,
Name as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/VariableDescription]);
//Report:
OUTER JOIN LOAD
filepath() as FileName,
Id as ObjectId,
'Report' as SOE_Type,
Name as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Report])
WHERE Id > '';
//BookmarkItems:
OUTER JOIN LOAD
filepath() as FileName,
BookmarkId as ObjectId,
'Bookmark Item' as SOE_Type,
BookmarkField as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/BookmarkItems]);
//Bookmark:
OUTER JOIN LOAD
filepath() as FileName,
BookmarkId as ObjectId,
'Bookmark' as SOE_Type,
Name as Label
FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Bookmark]);
Hope this will solve many of your problems.
Regards,
Kaushik Solanki
Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
