Interested to Buy Any Domain ? << Click Here >> for more details...
What is Cognos Powerhouse and what is it used for?
- 2 Answers
- 14606 Views
- IBM, M Care, I also Faced
- E-Mail Answers
Answer Posted / bob edis
Cognos PowerHouse (4GL, Web, Axiant) is an Application
Development tool. It was Cognos' main bread&butter product
prior to BI tools beconing so popular. It's hayday was in
the 1990's as it was for most 4GLs. 4GLs went out of focus
for most IT depts when Java became king of the programming
languages.
This is not to say 4GLs are irrelavent. They posess
attributes which still make them the faster method of
delivering robust, data driven business applications in a
much shorter time than OOP/3GLs.
PowerHouse uses a data dictionary (similar to the meta data
repository used by Cognos 8 BI) so programmers don't have
deal with file/table handling and discovering data
definitions. It comes in three flavours - terminal based,
client-server (Axiant) and web. There is a report writing
tool (Quiz, Cognos' original product when it started as
Quasar in 1969), form generator (Quick), and a transaction
processor (QTP).
PowerHouse Web is a very good solution for data warehouse
implmentations that need to maintain reference data not
found elsewhere and therefore cannot be sourced using an
ETL process. It is multi-platform (UNIX, Windows, OpenVMS,
MVS, etc) and very scalable.
Cognos Transformer originally used PowerHouse technology
and some of it has found its way into other Cognos tools.
I believe Cognos should merge the data dictionary
components of PowerHouse and Cognos 8 BI so that the tools
can be integrated better.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Write types of folders present in cognos?
What are all the different types of prompt in cognos?
what is the difference between querystudio in reportnet and cognos8
Can you explain the advantage of using shortcuts?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
What are products of cognos?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is difference between primary key and unique key constraints? write a query to display the departments with no employee? 2. What functional area you worked on.
How to generate cubes in cognos? WHAT ARE THE DISTNICT VARIABLES? can you tell me what are the dimension tables are used in project
