SSAS Tabular migration to GCP

Question

Post reply

SSAS Tabular migration to GCP

squareoff

Mr or Mrs. 500

Points: 587
More actions
November 9, 2022 at 9:35 pm

#4110724

Hi,
I am recently involved in a project where we are trying to migrate all the workloads from SQL Server to GCP. In our environment we have an SSAS Server, which houses SSAS Tabular cubes. Analysts connect to the cubes via Excel Pivot and utilize the data.
We are considering to replace SSAS Server/Tabular Cubes with a denormalized dataset (e.g. materialized view) in BigQuery. One challenge is the ability to connect from Excel to BigQuery and interact with it the same way it is done when Excel connects to Tabular cubes. Excel does not seem to have a native functionality available (or at least I can't seem to find it).
Has anyone faced a similar issue and come up with a solution for replicating SSAS Tabular use cases in GCP? I am trying to avoid setting up a VM in GCP and installing SSAS on it.
Please advise,
Thank you in advance!
November 16, 2022 at 6:50 am

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 2

squareoff wrote:

We are considering to replace SSAS Server/Tabular Cubes with a denormalized dataset (e.g. materialized view) in BigQuery.

Why? What "magic" do you folks expect to suddenly occur? Stop an think about what you said...

squareoff wrote:

One challenge is the ability to connect from Excel to BigQuery and interact with it the same way it is done when Excel connects to Tabular cubes.

I'll emphasize the words you spoke which are "the same way it is done [currently]".

There appears to be no advantage if you're just going to do things the same way. So... Why? What is the "magic" that you expect to happen other than using other people's computers?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)