what is the difference b/w mdx and sql?

Answer Posted / karthik

MDX - Is the Multi Dimensional SQL.
Just like we have SQL for Oracle or MS- SQL (which are
nothing but Relational Data Bases ), The Query or the
Syntax for Multi Dimension Data Source like CUBE or other
OLAP data source use MDX.

So the PowerPlay Transfer uses MDX for building the CUBE.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between regular dimension and derminant?

1692


What are various types of gateways in cognos?

545


what are slowly changing dimensions? Why we are used scd?

619


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

1709


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1500






what is log in cognos?

666


What is the difference between the standard and metrics folder?

505


What DB View and Bus View?

1544


Why are meta service important then other services?

588


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10751


Define metrics studio?

583


Can you define transformer?

522


what is a prompt value in report studio and variables ?

2168


What is a Transformer?

653


What is difference between content store and content manager?

549