Hi Friends,I am stuck with work can u plz do needful.Having 3 Excel files in almost all columns all dimensions are common some are differ i concatenated generated qvd.In separate sheet i need Conditions to measure all
[Retail Model]: NoConcatenate Load [Order No] , [Pick Slip No], [Manager Code], [CustId], Source, Minor, Class,sum([Retail Amount]) as [Amount] Resident [Model] Group by [Order No],[Pick Slip No],[Manager Code],[CustId],Source,Minor,Class
I need to get all data at script level.First loading one data source used whereMatch(Status,'MA','TH'); and used group by with dimension for all measures separately in script and generated qvd separetly,synthatic keys are forming i.e,Need all script in temp like table where calculations are to be done not changing sources.In detail i have another source where almost all dimensions are same ther is no primary key but at final both are to be compared side by side.
the dimensions in Model,sales,Loss.xlx all are checked in pivot table.
The Dimensions are common in all excels
Pick Slip No
Sales.xlx Measure: Puchase
Loss.xlx Measure: Net Loss
Amount Values act like a hyperlink on clicking it chould populate pivot table with default dimension and matching should show Amount at lowest drill downs.
2)To show Welcome tab first scrren with current user login Name