Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w mdx and sql?
- 4 Answers
- 21515 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 |
what is sdibling function tell me the some functions
What is cognos reporting tool?
explain how to create powerplay reports?
What is difference between content store and content manager?
What is a Pivot?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is render variable?Where do you exactly use in developing a report?
Can you define a datastore in cognos?
Define the slice and dice?
diff b/w dimension and regular dimension
Teradata 
