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
What is the difference between regular dimension and derminant?
What are various types of gateways in cognos?
what are slowly changing dimensions? Why we are used scd?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
what is log in cognos?
What is the difference between the standard and metrics folder?
What DB View and Bus View?
Why are meta service important then other services?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Define metrics studio?
Can you define transformer?
what is a prompt value in report studio and variables ?
What is a Transformer?
What is difference between content store and content manager?