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

Problem with Business Date/Time Function

Started by Venu_Gollapudi, 11 Nov 2007 11:56:33 PM

Previous topic - Next topic

Venu_Gollapudi

Hi,

When I am trying to retrieve week of the year for a perticular date by using the function _week_of_year I'm getting the following error:

RQP-DEF-0177

An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.
 

Also note that the same[_week_of_year] is working for the relational models, but I want the same work for dimensional model for which cube is the data source.

Can any one help on this......

Thanks in Advance.
V.