what is the difference b/w mdx and sql?
Answer Posted / 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 |
Post New Answer View All Answers
--------------Explain Table of contents?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
Can you define folder?
What is the difference between the standard and metrics folder?
What is the size of the cube?
What is defined as data mining?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Can you define materialized view?
Explain informatica architecture?
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 ?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
How security is concerned with Reportnet? Explain its implementing steps.
What is main difference mapplets and mapping?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What is the model filter?