Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

what is the difference b/w mdx and sql?

Question Posted / ambareesh.ko

Answers were Sorted based on User's Feedback



what is the difference b/w mdx and sql?..

Answer / k srinivas

MDX is a multidimensional expression, we can query directly
to OLAP source by using MDX and SQL is a structured query
language, where as we can query to the RDBMS source.
When we r dragging the query items into the report area
automatically MDX generated that query will send to the
OLAP source directly.

Is This Answer Correct ?    15 Yes 4 No

what is the difference b/w mdx and sql?..

Answer / 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

what is the difference b/w mdx and sql?..

Answer / pratap gangula

SQL is a standard language for retrieving data from RDBMS
while MDX is a standard language to retrieve the information
from a cube.

Is This Answer Correct ?    9 Yes 0 No

what is the difference b/w mdx and sql?..

Answer / surendra

By using mdx we can retrieve the data from the analysis service where as sql retrieve the data from relational database.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Cognos Interview Questions

What are the different kinds of panes included in cognos?

0 Answers  

What are the different types of important services used in cognos?

0 Answers  

What is catalog and types of catalogs in cagonos and which is better?

0 Answers  

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,

does query is created for date prompt?

9 Answers  

How Metrics Studio is better than Report Studio?

0 Answers  

Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,

What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  

can you apply grouping on crosstab?

1 Answers   CTS,

What is difference between page break and section report?

0 Answers  

what is hints in cognos and where we use it.

0 Answers   Satyam,

------------------What is Focalpoint?

1 Answers  

For more Cognos Interview Questions Click Here
Categories