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
- 33513 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 |
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
What is the difference between ‘macro’ and ‘prompt?
What is minimum version of internet explorer to run the Cognos report.
What is Normalization?
What are all the types of indexes in Cognos?
what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?
1 Answers Dr Reddys, TCS, Thomson Reuters,
i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....
what are the limitations of cognos reportnet?
11 Answers IBM, Nestle, TCS,
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
what r the filters in fwm and report studio
What is the metric store database?
What is a Folder?
Teradata 
