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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Relationships/Scope and Framework Manager

Started by Eve, 09 Mar 2007 12:02:46 PM

Previous topic - Next topic

Eve

Hello Gurus !

I am new to Framework so I will appreciate any information that I can get from you ...

I used to work with Transformer for many years, now I am having a problem trying to understand the Framework methodology.

I have installed the framework in my computer and i am trying to use the gosales_goretailers.
I am using a Oracle 9i database.

It has the database_view relationships between Go Sales and Go Retailers and at the top we have the gosales_goretailers namespace.

My question is : All the data inserted in Orders, Products came from the database_view and the query runs properly and everything works fine while it is on Framework ... But when i publish the package, for example , if i try to make a report in report studio, using orders and products, it just doesn't allow. What step am i missing ?


For example , I wanted to bring order_number from Orders and Product Name from Products ...
It returns ...

QE-DEF-0030 Expression parsing error.

QE-DEF-0143 Invalid object.

[gosales_goretailers].[Orders].[Product number]

Trace back:

WPBIBusMethod.cpp(174): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(173): WPDataRetrievalException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(145): WPDataRetrievalException: WPExecuteRequestThread::checkException

WPEngine.cpp(950): WPDataRetrievalException:

WPController.cpp(237): WPDataRetrievalException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(313): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare

LWDataRetrievalEngine.cpp(1681): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery

Source/CQEConnection.cpp(366): QSException: CCL_RETHROW: CQECommon

Source/CQEConnection.cpp(365): QSException: CCL_CAUGHT: CQECommon

Source/QE_QsApi.cpp(2960): QSException: CCL_THROW: QE

*******************************




Sometimes, if i just want to create a report with the product name , it just doesn't bring anything... I am confused ...

Does Framework use the same methodology like Transformer used to use while creating the models?

There's any place where we can see what is in scope with the fact table ? I know there is "Specify Dimension Information" , but somehow it's not clear for me.

Maybe i am asking something stupid, but it's been sometime...

Yes, i have read the manuals that came with the software, but nothing like talking with people that use the software right ?
Thanks !

blom0344

I am new to Cognos , having a Business Objects background. I took a fasttrack Cognos8 course expecting that with more then 10 years of BO experience it would be possible to learn the ropes quite quickly. How wrong I was, Framework manager looks impressive, but I can't make head or tails from it.

If you work the way it is supposed to be , then SQL generated is really awful. Even a very simple report comes up with real messy SQL.

When you create a report in report Studio did you check the SQL generated? This may give you a clue in the case where you just try to fetch productdata. You will be surprised about the complexity...

In creating the package ,did you include the databaseview namespace? I think this is absolutely essential (but stand to be corrected)Ã,Â