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 is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

1 Answers   Cognizant, Niteo, SacSoft,

How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,

Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?

4 Answers   IBM, Wipro,

Is it possible to create drill through access to other report from PDF report?

1 Answers   IBM,

Explain about embedded & standalone filters?difference between them

1 Answers  

How to connect three fact tables?

11 Answers   L&T, TCS,

what is meant by roll up and roll back in dataware housing????

4 Answers   Covansys, IBM, Wipro,

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers   CTS,

how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,

example for generated prompt

1 Answers  

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

write a query to display the third record from the employee table?

4 Answers   HCL,

For more Cognos Interview Questions Click Here
Categories