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

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,

7. What is performance tuning?

0 Answers  

what is catalog and types of catalogs in cagnos and which is better?

0 Answers   IBM,

what r the names of the reports that u prepared???

9 Answers   Covansys, IBM, Wipro,

I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

2 Answers   IBM,

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers   BitWise,

pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com

1 Answers  

-------------What is Coditional Prompting?

0 Answers   IBM,

what is the difference between list report and crosstab report?

0 Answers   IBM,

What are the batches and it’s details?

0 Answers  

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,

How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?

1 Answers   Polaris,

For more Cognos Interview Questions Click Here
Categories