How to get data from OLAP?

Question

OLAP

There is Analysys Server on which OLAP is built.
Tell me how to get data from this OLAP server to another Database server to save it as a table. Perhaps mdx is needed here?
I use SQL Management Studio. What else is needed?

Answer 1

for example, use Linked Server
and constructs by analogy:

select * from openquery(LINKED_OLAP_SERVER, 'SELECT NON EMPTY _
{ [Measures].[Sales Amount] } ON COLUMNS FROM [Sales]')

Answer 2

Ravze in Management Studio can execute mdx queries to the Analysis Server?
I have Management Studio and Visual Studio at my disposal.