How create a chart from a query? 1

[pramsam1]

I am very new to this. Using Report Studio. Database is Oracle 9. I am trying to create a chart from the results out of a query on oracle. I have dragged and dropped query items into the chart as guided in the user guide. But when I run the report, my chart is empty. Do you have to do anything special with the data out of the oracle query before you can use the data items for the charts???? Much appreciated.

 

[blom0344]

The main issue is that if you do not specify an aggregate explicitly on the measure, then Cognos will ALWAYS generate an empty chart.
So, check the aggregate property of the measure. I bet this is yet undefined..

Ties Blom

 

[pramsam1]

Great help. Thank you very much.

 

[geethkal12]

Hello All,

How to build queries on the top of the chart in report studio?

thanks for your help
divya

 

[blom0344]

How to build queries on the top of the chart in report studio?

Can you clarify what you mean?

Ties Blom

 

[geethkal12]

i need to build a small line graph from audit database showing performance report for the enduser and have to integrate with cognos connection portal pages.I got to create queries on the top of graph to get to know the performance whoever logs in and using cognos environment.

I managed to build a line graph in Report studio taking time dimension on X-axis and Execeution time of reports on Y-axis. but the requirement is i got to get day names (mon tue, wed thru, fri, sat, sun)on X-axis which i was failed to get. On y-axis i have to take two measures average execution time and Maximum execution time and that appear in two different colors on Y-axis.
And i need to get some information just above the graph like:
No. of users online today =
Reports run today =
Percentage of reports Succeded =
Does that make sense? i trying this from the past one week but i am not getting it. Please help me in this regard.
Your assistance is appreciated

 

[blom0344]

Use a table with 1 column and four rows and put the graph in the lowest cell.
If the additional info is coming from seperate queries than insert lists in the 3 remaining cell and hide the columnheaders of the lists.

You can easily compute the days like:

CASE 
WHEN
_DAY_OF_WEEK([SOMEDATE],1) = 1 THEN 'mon'
_DAY_OF_WEEK([SOMEDATE],1) = 2 THEN 'tue'
_DAY_OF_WEEK([SOMEDATE],1) = 3 THEN 'wed'
_DAY_OF_WEEK([SOMEDATE],1) = 4 THEN 'thu'
_DAY_OF_WEEK([SOMEDATE],1) = 5 THEN 'fri'
_DAY_OF_WEEK([SOMEDATE],1) = 6 THEN 'sat'
_DAY_OF_WEEK([SOMEDATE],1) = 7 THEN 'sun'
ELSE '' END

Ties Blom