I'm a newbie to SSAS OLAP so please apologize me if it was a silly question but surely I need suggestions. I would like to make clear some concepts which was confusing for me.
Let us consider five tables:
1. FileImport 2. DepositLog 3. Divisions 4. CardDetail 5. Date
Here, the process is, I'm importing a deposit file to database so the file details like name, date and time will be imported to FileImport table.
The data inside of the file will be imported to DepositLog.
The Divisions table will have the clients detail and the CardDetail has the card types and card holder data details.
So, DepositLog will have primary-foreign key relationships to FileImport, DivisionID, Date and CardDetail.
FileImport has columns as shown below
1. FilePkId 2. FileName
Divisions has columns as shown below
1. DivisionPkId 2. DivisionName
CardDetail has columns as shown below
1. CardPkID 2. CardNumber 3. CardExpDate
1. DatePkId --> has date as key value 2. Monthname 3. Yearname
DepositLog table has columns with primary-foreign key relationship to all those above four tables:
1. Id 2. FileFkId 3. DivisionFkId 4. CardFkId 5. DepositSubmitDate --> has foreign key relationship with (DatePkId from Date table) 6. DepositUnit --> numeric value column
When adding the table to DSV, do I need to specify the same relationship between those tables as specified above?
When creating a dimension for DepositLog table, what are the dimension attributes we have to select into it?
How to define the attribute relationship for those attributes in DepositLog dimension?
Is that necessary to create or set attribute relationship even if the dimension has no hierarchies in it?
How does the tables are joined in SSAS and whether in DSV or dimension or based on Dimension Usage that we have specified ?
Please suggest me some links which may help me to gain insight into SSAS.
Please guide me through the following and thanks in advance.