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

Define olap designer?

0 Answers  

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

2 Answers   IBM,

What is a Transformer?

0 Answers  

------------ Diff b/w MemberCaption and MemberDescription?

0 Answers  

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

0 Answers  

diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

0 Answers  

what is the difference between rollup aggregation and aggregation ?

1 Answers  

how can you get the errors in job? when loops are araised we get error?

0 Answers   Syntel,

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

2 Answers   IBM, Infosys,

what is stitched query???

2 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories