BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Aggregate Aware Filter parse error in UDT


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
bittu
Forum Member
Forum Member



Joined: 09 Nov 2010

Posts: 11



PostPosted: Fri May 03, 2019 3:49 pm 
Post subject: Aggregate Aware Filter parse error in UDT

Hello - I was able to write @aggregate_aware condition inside a where clause of an filter object in UDT 4.x.
I'm not able to Parse the filter condition however, when I pull this filter object into a webi report it runs fine without any error.
But when I try to parse it at universe level it throws the below error message:
Parse failed: Exception:DBD,ORA-00903:invalid table name state:N/A.
I tried various ways but no luck icon_sad.gif

Where condition in the filter object:
@Aggregate_Aware(SC_DIM_RES_TEAM.IS_CURRENT,SC_DIM_RES_TASK.IS_CURRENT,SC_DIM_RES_WIP.IS_CURRENT,SC_DIM_RES_MASTER.IS_CURRENT)='Y'
Back to top
bittu
Forum Member
Forum Member



Joined: 09 Nov 2010

Posts: 11



PostPosted: Mon May 06, 2019 10:04 am 
Post subject: Re: Aggregate Aware Filter parse error in UDT

Any replies are appreciated!
Back to top
CSM07
Forum Member
Forum Member



Joined: 15 Nov 2016
ASUG Icon
Posts: 23



PostPosted: Fri May 10, 2019 9:58 am 
Post subject: Re: Aggregate Aware Filter parse error in UDT

This problem does not occur in IDT.I have seen this behaviour in UDT ,however it works fine at report level and so it shouldn't bother you. The only way i came across to fix it was to define the condition in an object and then use this object in the condition object.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11462
Location: Manchester, UK


flag
PostPosted: Mon Jun 10, 2019 7:32 am 
Post subject: Re: Aggregate Aware Filter parse error in UDT

It works similar to the way that sydate doesn't parse but works with other objects fine.
The UDT parser has been around for over 20 years and works fine in most instances. In this case, it doesn't know which route to take (yet) as it isn't in a query; as such it doesn't have a simple structure to parse, so it doesn't parse anything. Don't worry about it.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0279 seconds using 17 queries. (SQL 0.0030 Parse 0.0008 Other 0.0241)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo