Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w mdx and sql?
- 4 Answers
- 21164 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
What are Governer Settings?
Give me any example of semi and non additive measures?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Why cognos decision stream is used?
is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)
What are all the types of report?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
What is Render Variable? where u can use?
Can you explain model durability?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
Teradata 
