CODEWITHSUNDEEP
sqlssasmdxolapstar-schema
Chiko
Chiko

Reputation: 1

Querying Dimensional Model or schema using Java and SQL

I have a star schema with information/data and I want to write the sql query to pull data from the star schema and then embedd that sql in java application. where can I start from? or are there tutorials that can help me to write java application that can be pulling data from Dimensional Model? Like the way it is MDX Microsoft analysis services?

Upvotes: 0

Views: 172

Answers (1)

MoazRub
MoazRub

Reputation: 2911

You need to be clear about a few things:

Analysis Services is an OLAP engine. It has preprocessed data stored in it, which is extracted using MDX. The Analysis Services pulls data from transactional database tables, which are organized in a dimensional model.

Now if you want to pull data from dimensional model using Java you can make a view or write custom SQL on the dimensional model and query that to get relevant data. This will be just like querying tables in database. However if you want to query the OLAP engine you use MDX to query. In .net you have adomd for querying in MDX.

Upvotes: 1

Related Questions