1.How do i decide if i need to look at reports and then create a DW schema or should i create a dw schema with all the fields possible and then create reports off it? Please Provide Insight.
2. I have tight deadlines. In such a case can i simply create a view on SSAS and source it to the reports by creating cubes. In such a case, do the cubes need to be created every night?? Please help.
3. can these cubes be reported from any tool such as crystal reports or does it have to be SSRS?
View Complete Post