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.

What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  

---

I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh

2 Answers  

---

How do you test the performance of a report?

3 Answers   TCS,

---

How to select all in value prompt instead of cascade prompt?

3 Answers   IBM,

---

-----------What is member Description?

2 Answers  

---

what is conditional query subject and example

2 Answers   TCS,

---

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers  

---

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

---

How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,

---

how you create security to reports?

0 Answers   IBM,

---

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

4 Answers   Mphasis,

---

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

---