ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Cognos
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the difference b/w mdx and sql?
 Question Submitted By :: Ambareesh.ko
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference b/w mdx and sql?
Answer
# 1
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 ?    0 Yes 0 No
Karthik
 
  Re: what is the difference b/w mdx and sql?
Answer
# 2
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 ?    1 Yes 0 No
K Srinivas
 
 
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
how u provide security in power play transformer??? iFlex1
how many types of keys are there i.e primary key and foreign key etc..? IBM1
what is tabular set? how can you break the report? Syntel1
actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?  1
what is an outer join? difference between left outer join right outer join with an example? HCL1
write a query to display the third record from the employee table? HCL2
How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD? TCS1
set scope level in transformer  1
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,, Tech-Mahindra1
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?  2
How can we improve performance in framework manager level? Wipro2
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail...... Tech-Mahindra1
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package? TCS3
How to perform single signon in Cognos by using URL?  1
what is loop in frameworkmanager ? Texas3
what is an associated query?  2
does query is created for date prompt?  2
What is meant by Tabular SQL in Cognos Report net Infosys2
where do we see the run time of the report ?  1
cognos is holap or molap or rolap Cognizent4
 
For more Cognos Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com