NEED HELP IN DBSA

Post Reply
sh226
Posts: 30
Joined: Wed Jun 06, 2012 8:59 pm
OLAP Product: TM1
Version: TM1 9.5.2
Excel Version: 2010

NEED HELP IN DBSA

Post by sh226 »

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.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: NEED HELP IN DBSA

Post by tomok »

This is pretty basic stuff that can be handled in a TI process using the wizard. Suggest you read the TM1 manuals, especially the section about TI processes.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply