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.

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1877

---

Can you define slice?

976

---

how can you get the errors in job? when loops are araised we get error?

2057

---

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?

4655

---

What is looping and how to avoid it in framework manager?

1151

---

Explain what is the difference between microstrategy and cognos reporting tool?

1004

---

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2252

---

tell me two or three issues from client side and how to solve those issues?

2109

---

4. How many dimensions did you use in your reports?

1891

---

Name the types of gateway?

964

---

What is a Pivot?

1043

---

what is the difference between filter and condition?

1017

---

What are the types of catalogs in cognos?

1092

---

What is the difference between set functions and filter function in dimensional data?

2850

---

What is meant by alternate drill down with ex?

1031

---