Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Model:
LOAD [Order No] ,
[Pick Slip No],
[Manager Code],
[CustId],
Source,
Minor,
Class,
Local,
Number,
Model Group,
Status,
ModelNo,
Amount as [Retail Amount]
where Match(Status,'PG','PC');
[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 where Match(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
:Order No
Pick Slip No
CustId
Source
Minor
Class
Model.xlx Measures:Income
Sales
Sales.xlx Measure: Puchase
Ledger
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
All measure are to be displayed
Learn about Drill Down Group. Or, you can take two objects (using conditional appearance).
In script to get different measures i need a solution to get all script together not like above script which have written for individual calculations.Measure with corresponding Amounts
can Any one help me in scripting?started discussion