NEED HELP IN DBSA
Posted: Wed Sep 05, 2012 9:04 pm
Hello all, Please help me on this.
I have one cube that has several dimensions including PERIOD dimension and one dimension call "ABC" which is basically a measure dimension that holds my flat file data and has 10 elements.
The requirement is to add few more elements in "ABC" measure dimension but those elements are coming from different flat file source and it has structure like this:
Date Name TotalResident ResidentValid TotalProspect ProspectValid
Aug 2012 1130823 Alexander Court 481 436 295 243
Aug 2012 1130824 Parkside at Lake Creek 515 407 254 212
Aug 2012 1130825 Andover Place 553 433 669 591
Aug 2012 1130820 Aspen Court 184 171 152 137
Aug 2012 1130819 Autumnwood 403 353 1027 837
now i want last four columns data to be added in the existing cube. I am thinking to send these by using DBSA formula but i dont know how i would use period and Name and other elements to match. Thanks in advance for your help.
I have one cube that has several dimensions including PERIOD dimension and one dimension call "ABC" which is basically a measure dimension that holds my flat file data and has 10 elements.
The requirement is to add few more elements in "ABC" measure dimension but those elements are coming from different flat file source and it has structure like this:
Date Name TotalResident ResidentValid TotalProspect ProspectValid
Aug 2012 1130823 Alexander Court 481 436 295 243
Aug 2012 1130824 Parkside at Lake Creek 515 407 254 212
Aug 2012 1130825 Andover Place 553 433 669 591
Aug 2012 1130820 Aspen Court 184 171 152 137
Aug 2012 1130819 Autumnwood 403 353 1027 837
now i want last four columns data to be added in the existing cube. I am thinking to send these by using DBSA formula but i dont know how i would use period and Name and other elements to match. Thanks in advance for your help.