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.

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.

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.

Answer / surendra

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

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,

---

what is fact less fact give me proper example?

2 Answers  

---

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

0 Answers   CTS,

---

what are the features in cognos8ui

0 Answers   HSBC,

---

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

---

Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !

3 Answers  

---

where we use page break  and page set. with example?

1 Answers   CNSI, IBM,

---

I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?

1 Answers   Facebook,

---

What is defined as data mining?

0 Answers  

---

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

0 Answers   IBM,

---

1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 Answers  

---

what is log in cognos?

0 Answers   IBM,

---