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
i couldn't get the relation b/w create sectioning and graph...plz brief us more abt the problem...
Srik
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