1

Topic: Data migration of Cuba => Table SQL. How?

All greetings;
Head broke, I do not know what to do.
There is cube SSAS, the user builds schedules of its data. Now it is necessary to make so that the data for these schedules (digit) was brought in table SQL.
There a problem that the old data (till 2017) is not anchored to a cube and sit in the table, and the new data (since 2017) needs to be dragged already from a cube. Therefore made the separate table which stores all all digits and therefrom we build the report. A problem: how to add the new data in this table of a cube? I.e. as though to address to a cube from SQL easier?
Thanks.

2

Re: Data migration of Cuba => Table SQL. How?

User2155;
I would make through SSIS a packet. Wrote MDX request, it used as data source, and forward...

3

Re: Data migration of Cuba => Table SQL. How?

User2155 wrote:

There is cube SSAS, the user builds schedules of its data. Now it is necessary to make so that the data for these schedules (digit) was brought in table SQL.

if talk about detailed  will be extremely slowly (certainly depends on that how many at you the data, but in general it very much not fast process)

4

Re: Data migration of Cuba => Table SQL. How?

Creating a Linked Server for Analysis Services
Properties of a line of connection (service Analysis Services)
How to perform an A SQL Server distributed query with OLAP Server
Client Libraries used for Analysis Services connections
Connection with a tabular template of databases (SSAS)
Creation  servers (Linked Server) for MS Analysis Services

5

Re: Data migration of Cuba => Table SQL. How?

User2155;
And whence this data comes to a cube? Can is easier to take from this source?
2) links above (mdx requests)
3) a stupid single variant - from a cube  in an ex-fur-tree, from  load to itself

6

Re: Data migration of Cuba => Table SQL. How?

StarikNavy;
I think time in a cube is loaded means from a cube faster to get  the data than from whining to pull
User2155;
adjust and can easy do select * from openquery

7

Re: Data migration of Cuba => Table SQL. How?

For example
SELECT
*
FROM OPENROWSET (' MSOLAP.6 ', ' DATASOURCE=YOURANALYSISSERVER; Initial Catalog=ANALYSIS_DB; Integrated Security=SSPI; Impersonation Level=Impersonate; ';
' SELECT NON EMPTY {[Measures]. [Mesure1]} ON COLUMNS FROM [CUBE1] ') AS a

8

Re: Data migration of Cuba => Table SQL. How?

User2155;
Consider a variant to take the data from the table, whence their beret itself cubic

9

Re: Data migration of Cuba => Table SQL. How?

wrote:

User2155;
Consider a variant to take the data from the table, whence their beret itself cubic

If the data is aggregated and added calculated measures, it not a variant.
Already wrote, is easier through SSIS a packet.