If you are unable to create a new account, please email support@bspsoftware.com

 

Is report studio able to create a report using Dimensional package modeled by FM

Started by vignesvar, 22 May 2015 01:48:42 AM

Previous topic - Next topic

vignesvar

Dear Chaps,
I'm using Cognos 10.2 and Mysql as DB to create a report. When I create a report using dimensional package. It shown an error "system busy" or "out of memory".  Report studio able to generate a report using dimensional package? Package is modeled by FM. then
I create a report in cross tab format getting report in resource wise I got a exact results same query getting report in client wise, results is wrong. I found some fields in the cross table value automatically twice it. Help me to resolve this issues.
Thanking you.

Francis aka khayman

Yes you are supposed to be able to create report from a Dimensional package using Report Studio.

System busy or out of memory errors seem to point to something wrong in the server side.

The second paragraph I can't understand.

Quote from: vignesvar on 22 May 2015 01:48:42 AM
Dear Chaps,
I'm using Cognos 10.2 and Mysql as DB to create a report. When I create a report using dimensional package. It shown an error "system busy" or "out of memory".  Report studio able to generate a report using dimensional package? Package is modeled by FM. then
I create a report in cross tab format getting report in resource wise I got a exact results same query getting report in client wise, results is wrong. I found some fields in the cross table value automatically twice it. Help me to resolve this issues.
Thanking you.

vignesvar

Thank you khayman, I have one more query. I'm creating a report in cross table format using work id to get the budget and actual time for that particular person. Here budget value 10 in database but report studio report are showing many time value multiple and printed in the report like budget value as 10, Report studio report budget are 50. I don't know why it is happen. work are classified by purpose and purpose classified by act. some times actual and budget value both are shown multiple of normal values. Help me how to resolve this problem quickly.

Raghuvir

Quote from: vignesvar on 25 May 2015 04:03:35 AM
Thank you khayman, I have one more query. I'm creating a report in cross table format using work id to get the budget and actual time for that particular person. Here budget value 10 in database but report studio report are showing many time value multiple and printed in the report like budget value as 10, Report studio report budget are 50. I don't know why it is happen. work are classified by purpose and purpose classified by act. some times actual and budget value both are shown multiple of normal values. Help me how to resolve this problem quickly.

Hi,

check the aggregate function of the data item. currently what is the aggregate function of the measure set to ? also check the auto group and summarize property of the query.

Regards

vignesvar

Thank you Raghuvir, I got a result.
Have a nice day
Cheers :)

Regards,
VIGNESVAR.A