cognos is holap or molap or rolap
- 7 Answers
- 25242 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
ROLAP---------------- It is related to Cognos Reportnet.
MOLAP---------------- It is related to Cognos8.
HOLAP---------------- It is A combination of MOALP+ROLAP.
So that we will use in HOLAP in Cognos 8 BI Suite.
Note:
In Reportnet---------- we doesn't have Drillup and Drill
Down.
In Cognos 8 BI Suite-------------- we can do Drillup and
Drill down.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ez
Cognos 8 and report net are both ROLAP and MOLAP and
possibly HOLAP.
MOLAP = Cubes
ROLAP = Dimensions Model directly accessing the data and
generating the OLAP analysis on the fly
HOLAP = Hybrid where where both ROLAP and MOLAP are used.
i.e. aggrgations at some set level are in a MOLAP Cube and
then once a set granularity is achieved it will then switch
to ROLAP
The power of Cognos is the ability to combine seamlessly
these sources as well as other within the meta-data and
have access to them though Query Studio and report studio.
You can drill up and down in report studio, query studio
and analysis studio.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / arkchowdary
ROLAP---------------- It is related to Cognos Reportnet.
MOLAP---------------- It is related to Cognos8.
HOLAP---------------- It is A combination of MOALP+ROLAP.
So that we will use in HOLAP in Cognos 8 BI Suite.
Note:
In Reportnet---------- we doesn't have Drillup and Drill
Down.
In Cognos 8 BI Suite-------------- we can do Drillup and
Drill down.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / venkat m
cognos reportnet is both rolap and molap.cognos8bi is same
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / honey
cognos reportnet is r-olap,bcz we can't do drill down $
dril up,
where as cognos8 is h-olap it can read the data from cube
so we can do drill down & drill up.
| Is This Answer Correct ? | 2 Yes | 3 No |
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?
Can we install cognos on windows 7?
------------What is Slicer memberset?
How is possible this scenario using in type-in prompt.?
What is the size of database for you project?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
is there any difference between operational database and data base?if yes what r they?
set scope level in transformer
What is the report studio?
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
Teradata 
