Problem on createing report using Dimensional package

[vignesvar]

Hi all,
I'm working cognos 10.2 with dimensional package. I have some problem while performing drill down concept in cognos that is.
1. When I run report using drill down or dimensional package report. It have too long time working report yet not display too(Loading the report not display in monitor).
2. I'm getting data from real time data base. generating report in long time My online DB Performance went to down. How to avoid DB going to down? Is my package design wrong?
3. I want to create a report in person wise budget and actual. Person in row, Budget and actual as a measure in column . In Dimensional package measure automatically summarize data so I'm getting wrong result in budget no problem on actual. How to get the exact budget value in dimensional package?
Please help me to build a correct report using dimensional package.
Note:
Person hierarchy: person is level, ID as businesskey, name as member caption .
Work Hierarchy : Work is first level, work ID as Business key, name as caption,
                               purpose is another level , work purpose as business key and caption.
Measure folder contain Actual and Budget value.

Thank you in Advance.

[MFGF]

Hi all,
I'm working cognos 10.2 with dimensional package. I have some problem while performing drill down concept in cognos that is.
1. When I run report using drill down or dimensional package report. It have too long time working report yet not display too(Loading the report not display in monitor).
2. I'm getting data from real time data base. generating report in long time My online DB Performance went to down. How to avoid DB going to down? Is my package design wrong?
3. I want to create a report in person wise budget and actual. Person in row, Budget and actual as a measure in column . In Dimensional package measure automatically summarize data so I'm getting wrong result in budget no problem on actual. How to get the exact budget value in dimensional package?
Please help me to build a correct report using dimensional package.
Note:
Person hierarchy: person is level, ID as businesskey, name as member caption .
Work Hierarchy : Work is first level, work ID as Business key, name as caption,
                               purpose is another level , work purpose as business key and caption.
Measure folder contain Actual and Budget value.

Thank you in Advance.

Hi,

What sort of dimensional package are you using? Is it based on an OLAP cube of some sort (and if so, what sort?) or is it a Dimensionally Modelled Relational (DMR) package sitting over a relational database? It sounds to me like you are experiencing severe performance issues? Unless we know what kind of data source you're reporting from there could be myriad different reasons.

MF.

[vignesvar]

Hi MFGF,
Thank you for response. I'm using DMR package for generating  reports in report studio.
Have a nice day

[MFGF]

Hi MFGF,
Thank you for response. I'm using DMR package for generating  reports in report studio.
Have a nice day

Ok - DMR. What is the underlying database? Are you connecting via ODBC? Native Client? JDBC? What is the structure of the database - is it using star schemas? What indexes are defined? How many rows of data are you spanning when you preform a drilldown?

MF.

[vignesvar]

HI,
JDBC Connection using to communicate DB. Text based structure. 17000 rows spanned average while drill down concept more over it is depend on the selection of period. Yes, It is star schema. I'm not defined any index in cognos.

[MFGF]

HI,
JDBC Connection using to communicate DB. Text based structure. 17000 rows spanned average while drill down concept more over it is depend on the selection of period. Yes, It is star schema. I'm not defined any index in cognos.

Ok - what database is it? SQL Server? Oracle? DB2? Something else?

Since you're using a JDBC connection, you can launch Dynamic Query Analyzer to see where your queries are hitting the database and where they are being fulfilled from the cache. Indexes are not defined in Cognos - it's a reporting tool after all. Indexes are defined in your database. You probably need to get some help in adding appropriate indexes to the underlying star schema tables to speed things up where your queries are hitting the database. Do you have a DBA or someone with good database skills you can go to for assistance?

MF.

[vignesvar]

Hi MFGF,
Thank you for your response, I'm using MySQL as back end.