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.

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

0 Answers  

---

how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,

---

What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

1 Answers   IBM,

---

What are variable report studio?

1 Answers   HCL,

---

How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.

3 Answers  

---

---

how u migrate reports to cognos 8 from previous versions

3 Answers   TCS,

---

Define olap designer?

0 Answers  

---

Write some methods to apply securities in framework manager model?

0 Answers  

---

Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 Answers  

---

What is the use of content store in cognos?

2 Answers  

---

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

1 Answers   IBM,

---

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

2 Answers   Satyam,

---