Interested to Buy Any Domain ? << Click Here >> for more details...
How can you improve performance in report studio level?
What is the difference between Cognos sql and Native sql?
How can you create cubes in framework manager?
- 7 Answers
- 35552 Views
- Genpact, iFlex, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / neelima
by using simple case statements and minimising the complex
calculations and applying the frequently used filter
conditions at the framework level instead of applying them
in the report level we can improve the performance.By
implementing distributed configuration we can improve the
performance.
we can create IQD's in the framework level and use these
IQD's to create cubes in powerplay.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / ushasree
report studio performance depends on net work spead,
complex calculations,using not in operator,outterjoin.
Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.
we can create package using cube.Cube is a data source here.
| Is This Answer Correct ? | 15 Yes | 10 No |
Answer / durga
The performance of a report depends on the network speed
and as a developer the following things should be taken
care. Use less number of complex calculations in the
report. Avoid using of conditional blocks and also avoid
unions in the reports.
To create a cube we need to create an iqd. and use this
iqd to create a cube.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / s ali
DMR is similar to cube. Has all member functions and drill down and roll up features.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sergio
I don't know exactly why but it seems that parameters in the
filters badly affect performances. Does anybody know why?
| Is This Answer Correct ? | 4 Yes | 7 No |
By using less number of filters, avoiding complex
calculations , and distributing configuration we can improve
performance in report studio ..........
cognos sql statement is created irrespective to database
but native sql statement is created respective to database
which is using .......
we can't create cubes in frame work manager ......there is
no other scope to create cube other than Power play
transformer....
If i am wrong ,point out me please...
It's madhoo
| Is This Answer Correct ? | 7 Yes | 11 No |
Answer / abc
u can create cube in FM using externalise property.
| Is This Answer Correct ? | 2 Yes | 11 No |
architecture of cognos8
Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls
How many reports did you create in your project?
What is the advantage of using shortcuts?
What are the types of hierarchies?
--------------what is MemberCaption?
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
How to apply securities for reports in cognos connection?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
how many facts&dimensions tables in project? it's very urgent.........
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Teradata 
