Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago

SSAS vs. ADW

hi   im converting my database from SSAS cube to azure database warehouse my problem in ssas was the limitations on live connection the first thing i wanted is the publish to web which enable on ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

MP_123 Add column is in the Desktop, because you don't have a model, and they are allowing you to create calculated columns. You can add any column or measure you want...

And to answer what "more" you can do, I don't really understand... You'll have the ability to add the additional calc columns and measures to the Desktop, and change relationships. "The model" part that you are now missing by using Direct Query to a database. I don't know if I've answered your questions, as the description is a bit confusing to me. You are going through all of this in order to use "Publish to Web"?

sairamchary1's avatar
sairamchary1
New Member
9 years ago

Hi ,

 

Can we replace a SSAS cube by a ADW solution ?

My current system is a OLTP  where the cube is a big blocker  ( it take a lot of time and effort .

Can we replace that with an ADW to show real time Data ?