what is the difference b/w mdx and sql?
Answer Posted / surendra
By using mdx we can retrieve the data from the analysis service where as sql retrieve the data from relational database.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a Pivot?
What is meant by drill down?
what is the difference between filter and condition?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Define report item?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
How the Bursting happens in same report and how to Print the bursting Report?
----------------Describe DWH Architecture?
How to select multiple values from type-in prompt?
---------------Describe OLAP Reporting and RDBMS Reporting?
how to create cubes in transformer ?
where you can save the report net documentation in our local system?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
Explain is there any comparison available for cognos reportnet vs crystal reports?