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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

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

Syntax error when splitting facta-definition in two layers


 
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
ChristianBr
Forum Member
Forum Member



Joined: 24 Sep 2019

Posts: 2



PostPosted: Tue Sep 24, 2019 5:33 am 
Post subject: Syntax error when splitting facta-definition in two layers

In my universe I use sum and case to get the desired result. If I put everything in one object, everything works OK.
Code:
sum(
  case
    when DWD_Kap.TAR = DWD_Vare.TAR
    then DWF_AGG.VERDI
    else NULL
  end
)

If I put only the field retrieved or the case-sentence in a separate object, and call it from another one, I get an error message saying the table doesn't exist.
That despite that showing SQL in the upper layer object is equivalent to the single-object code.

exception: dbd, The column prefix DWF_AGG does not match with a table name used in the query.

Code:
sum(
  @Select(Fakta\verdi, verdi)
) -- as Agg


Verdi:
Code:

case
  when DWD_Kap.TAR = DWD_Vare.TAR
  then DWF_AGG.VERDI
  else NULL
end


We want to use two (or three) layers for abstraction.
Any tips?
Back to top
ChristianBr
Forum Member
Forum Member



Joined: 24 Sep 2019

Posts: 2



PostPosted: Tue Sep 24, 2019 6:33 am 
Post subject: Re: Syntax error when splitting facta-definition in two laye

The problem was caused by the comment, -- As Agg.
Originally I had without --, but that didn't always work.
So now I replas with /* ... */.
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.0276 seconds using 18 queries. (SQL 0.0033 Parse 0.0008 Other 0.0235)
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