on procedure column can we use create section option

[aamuktha]

hi frnds,

               i want to generate a graph.

for eample :
                            i have three parameters dept id ,year ,month .
                            on emp name i have used create section option .all column are coiming from a procedure.
the output of my graph will be
                                in a given department ,year ,month all employees status will dispaly in graph.

i am facing a problem with create section option on procedure column.i have created a graph with the same approach which i have explained it above with view instead of procedure.I am able to excute the report.but when i have created the graph with procedure ,while running the report i am getting the following error


                        UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".

QE-DEF-0425 Exception was encountered while building the cube.

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(190): QSException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): QSException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): QSException:

WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(785): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets
LWDResultSetProcessor.cpp(423): QSException: CCL_RETHROW: LWDResultSetProcessor::getDetailQueryProcessor

Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE


thanks
aamuktha

[BIsrik]

i couldn't get the relation b/w create sectioning and graph...plz brief us more abt the problem...

Srik

[aamuktha]

Hi

Let me explain it briefly.

on procedure column i need to apply create section option.

i want to know will it work or not

thanks
aamuktha