April 10, 2008 at 5:03 pm
This might be a dumb question, but could you please explain me how SSAS 2005 constructs the SQL query when processing the cube?
In some cubes I get a simple SQL select from the fact table, but in some other cases it is a JOIN with some other dimension tables.
ps: I inherited the cubes from another developer and did not build them.
Any thoughts welcome.
Valentin
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 13, 2008 at 12:51 pm
The query is defined in the DSVs. If you don't change anything it is a straight select from a table. Or you can change it and it can be a very complicated join...etc. It is up to the developer.
Look at the DSV in BIDS or VS and see how it defined.
Susan
April 13, 2008 at 5:14 pm
Susan Shafer (4/13/2008)
The query is defined in the DSVs. If you don't change anything it is a straight select from a table. Or you can change it and it can be a very complicated join...etc. It is up to the developer.Look at the DSV in BIDS or VS and see how it defined.
Susan
Thank you for the answer. That's what I thought in the first place.
This was because I was trying to create a new cube with similar layout, measures, dimensions but could not make SSAS do JOIN.
So the question still remains - when does SSAS do a simple SELECT FROM [measureable] and under which circumstances does it need to do SELECT FROM [measeuretable],[dimtable1],[dimtable2]... WHERE ((..) AND (..) AND (..))
???
Thank you for your help
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 13, 2008 at 6:05 pm
[STRIPPED]
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply