Cognos Error Cannot Parse An Empty Expression
(troubleshooting) Problem(Abstract) Execution of an extract based on a PowerCube fails with an error message. Symptom QE-DEF-0482 Cannot parse an empty expression Cause The time dimension in the PowerCube being used as the datasource did not have its top level suppressed. Resolving the problem Using Transformer, suppress the top level of the time dimension and rebuild the cube. Historical Number 1036631 Document information More support for: Cognos 8 Business Intelligence Metrics Designer Software version: 8.1 Operating system(s): Windows Reference #: 1342430 Modified date: 2007-10-24 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 DACREE MarkDeVries 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 Craig Borysowich Dennis Stevenson Nikki Klein AbhaiTripathi http://www.ibm.com/support/docview.wss?uid=swg21342430 mircea_luca bluesguyAZ59 Clinton Jones knowscognosdoi iudithm Iqbalyk COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning 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 related to Cognos version 8, including Cognos 8 migration, configuration, http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/qedef0482-cannot-parse-an-empty-expression-whats-wrong-with-this-case-statement-3706151 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. QE-DEF-0482 Cannot parse an empty expression. What's wrong with this case statement? sql bddw asked Aug 19, 2010 | Replies (6) QE-DEF-0482 Cannot parse an empty expression. What's wrong with this case statement? CASE [product_type] WHEN 'Network' THEN ( CASE [classification] WHEN 'Hardware' THEN 'IT' ELSE NULL END ) ELSE NULL END Join this group Popular White Paper On This Topic The Six Questions Every IT Leader Needs to Ask 6Re
"real" OLAP cubes.I haven't posted much because I was gaining experience with Cognos PowerPlay Transformer - which I used as OLAP server. In this article I will share some of my http://unofficialcognostraining.blogspot.com/2009/01/from-dmr-to-real-olap.html experiences.Feeding a PowerCube with DataCognos offers different ways to set thedata sourcefor building a http://it.toolbox.com/people/sql321/posts?page=17 cube. One is more weird than the other.It supports CSV files... great. Who wants to do serious BI and build analytical cubes from comma separated text files?It support reports asdata source... also great. I guess it gathers the queries defined in a report... very very weird.Anyways... it offers one method which I would call "normal" cognos error and let's just forget about the rest: IQD.IQD stands for Impromptu Query Definition... Impromptu was a name of their product or something like that...The point is it's SQL with some metadata around it and perfectly readable in a text editor.Suggestions about IQDFirst I used Framework Manager to generate IQDs by "externalizing" query subjects.I found itunreliable... and it's not needed. Just write the SQL in a database utility and copy-paste into cognos error cannot the IQD file.Look at one IQD file in a text editor, it's a very easy format.I found that the name of the query doesn't matter.The columns in the SQL's result set are written after the SQL.Be careful not to end these lines with commas as the comma becomes part of the column name and that's quite annoying.On the long term I think it makes sense to have the cube update script create the IQDs. This way it can optimize the SQL that is run to generate the cube.e.g. include a time filter in the query and build the cubeincrementally.Otherwise the same SQL would be runevery timethe cube is built... which means regenerating the cube from scratch. Even if the cube is smart enough (partitioned etc.) the query still returns way too many records.Differences in Dimensional Model between PowerCubes and DMRIn DMR there are multiple dimension hierarchies and conformed dimensions. None of this is present in PowerCubes.I simply did not find a way to have multiple hierarchies in the same dimension. If someone knows that this is possible please send a comment. IMO it is not supported in PowerCubes.The lack of conformed dimensions mean that if say we have a Sales measure and an AdvertisingDollarsSpent measure
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 Michael Meyers-Jouan maxwellarnold TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Craig Borysowich Ramnath.Awate Dennis Stevenson Nikki Klein AbhaiTripathi mircea_luca bluesguyAZ59 Clinton Jones knowscognosdoi iudithm Iqbalyk COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT People sql bddw Connect Watch sql bddw United States Member since 3/24/2010 316 Posts 1 Member Connections 1 Achievements Cognos 8 EnthusiastContributed 15 posts in a group to earn a Bronze AchievementDate Earned: 8/22/2010 Profile Achievements Recent Posts Connections Posts From Connections Journal Calculating Changes in point in time: sales changes in today's sales and previous day sales. updated Aug 29, 2010 by sql bddw | Replies (5) I have created detail list report in Cognos 8.3 report studio where each row of the list contains... List report Summary on each excel tab/sheets updated Aug 30, 2010 by Pallavi123 | Replies (4) I am using Cognos 8.3. How do you do this? List report Summary on each excel tab/sheets updated Aug 30, 2010 by Pallavi123 | Replies (4) I have a list containing product information. PageSet is set to break on Product_ID. This creates... Detail filter based on negation, exclude condition updated Aug 25, 2010 by Randy | Replies (1) I have a condition which filters the data. But now I Need to get everything except this condition... Need a data item that does total(summing of Purchase price) updated Aug 25, 2010 by Rich Henderson | Replies (1) Simple question about totaling: Need a data item that does total(summing of Purchase price for... suggest a design strategy for detail and summary on left and rigt side Aug 24, 2010 I have one list report that di