I need to fetch data from SSAS database in SSMS using openrowset command
I am done with doing so by creating Linked server of msolap type and it works fine but I have to do the same without creating a linked server
please guide me how this task can be accomplished


Faheem zaki