Cognos Error Rqp-def-0149
Contents |
(troubleshooting) Problem(Abstract)
Rqp-def-0457
When running a crosstab report with measures dynamically assigned rqp-def-0177 based on a prompt value and you manually define a total measure you may receive the following errors: QE-DEF-0482 Cannot parse an empty expression. RQP-DEF-0149 The query specification is incorrect.RQP-DEF-0457 Referenced Query 'Query1_tab0' is not defined or its query items contain unresolved references. Note: Query1 can be replaced with whatever name of your crosstab source query is. Symptom For this example, Display Item consists of the following definition: if (?p_Choose_Option? = 'R') then ([Revenue]) else if (?p_Choose_Option? = 'Q') then ([Quantity]) else if (?p_Choose_Option? = 'M') then ([Margin]) else (NULL) Cause The issue stems from the fact that the aggregate function for the total measure may be set to Not Applicable. Resolving the problem Setting the aggregation to automatic will resolve the error. Example broken and working reports based on the Cognos 10.1.x GO Sales (query) sample package is attached. examples.zip Document information More support for: Cognos Business Intelligence Report Studio Software version: 10.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Software edition: All Editions Reference #: 1589465 Modified date: 2014-09-12 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Dennis http://www-01.ibm.com/support/docview.wss?uid=swg21589465 Stevenson Craig Borysowich Nikki Klein AbhaiTripathi bluesguyAZ59 Clinton Jones mircea_luca knowscognosdoi iudithm Adrian_Grigoriu COMPANIES Evault Wave Direct Quest Software Hewlett Packard View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Cognos 8 The Cognos 8 group is for the discussion of technical issues and concerns http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/rqpdef0149-query-specification-is-incorrect-4501106 related to Cognos version 8, including Cognos 8 migration, configuration, installation, and security. Home | Invite Peers | More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. RQP-DEF-0149 -Query Specification is Incorrect Elwood Lester asked Nov 8, 2011 | Replies (2) Dear Cognos Gurus, I am developing a crosstab report in Cognos 8.2. The main query comprises of a union of two queries due to different data values in the report and a data item for rank<=10. The queries
and session length News: Stay connected throught Twitter - Avnet Services, Twitter - Avnet Academy, LinkedIn, Facebook, Google+ and YouTube.Check out the latest IBM Cognos tips and tricks http://www.cognoise.com/index.php?topic=9036.0 in the BSP Chronicles. Join our Mailing List. Home Help Search Calendar Login Register COGNOiSe.com - The IBM Cognos Community » IBM Cognos 8 Platform » COGNOS 8 » Report Studio » RQP-DEF-0149 The query specification is incorrect. « previous next » Print Pages: [1] Author Topic: RQP-DEF-0149 The query specification is incorrect. (Read 4368 times) DolAny Full Member Join cognos error Date: Sep 2009 Posts: 9 Forum Citizenship: +0/-0 RQP-DEF-0149 The query specification is incorrect. « on: 16 Feb 2010 08:58:14 am » Hi, community.Could you land me you hand, please?Environmental:-DMR model.-Report Studio 8.4Task:I have products sold by price > 100$ and <0$ in different countries.I'd like to show within Crosstab:GEO and amount of products sold by price > 100$ and <0$ as three columns.My solution:- I create cognos error rqp-def-0149 Query2 with "GEO", "amount of products" and filter for products sold by price > 100$, "0" as value for column (calculated measure) that show products sold by price <= 100$,- I create Query3 with "GEO", , "0" as value for column (calculated measure) that show products sold by price > 100$, "amount of products" and filter for products sold by price <= 100$- I create UNION as Query 1Trouble:- The list is working perfect- the crosstab doesn't want to work and error occursError:RQP-DEF-0502 Master dataset can not be used for the provided query Query2 as they do not match. RQP-DEF-0149 The query specification is incorrect. RQP-DEF-0457 Referenced Query 'Query1_tab' is not defined or its query items contain unresolved references.Any help appreciated. Logged Doesn't work? We have Job! ;0))) Print Pages: [1] « previous next » COGNOiSe.com - The IBM Cognos Community » IBM Cognos 8 Platform » COGNOS 8 » Report Studio » RQP-DEF-0149 The query specification is incorrect. Avnet BSP Software Resources About Us MetaManager Podcasts Avnet BSP Software Integrated Control Suite YouTube Channel Avnet, Inc. Security Migration Twitter - Avnet Services IBM Cognos Apparo Fast Edit Twitter - Avnet Academy Accelatis Ascension Suite Webinars SMF 2.0.11