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: Upcoming Events: PGHBOUG: Aug 23.

Issue with @Variable('BOUSER')


 
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
charlie
Forum Associate
Forum Associate



Joined: 20 Aug 2002

Posts: 806
Location: Woodinville, WA USA


flag
PostPosted: Fri Apr 13, 2018 4:49 pm 
Post subject: Issue with @Variable('BOUSER')

BI 4.2 SP03 patch 5

I'm trying to use a security table to restrict which teams a user can see. In the IDT, I create a filter using a subquery that looks like this:
Code:
WHERE
  TeamName IN (SELECT [Security].Team from Security where NTLogon = @Variable('BOUSER'))
When I try to use it with a derived table, I get
Code:
The following database error occurred: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'myNTLogon'..
If I use the filter with a regular table, it works fine, as does running the code in SSMS with the value for NTLogon. I can't figure out why it thinks the result of @Variable('BOUSER') is a column name. If I parse the subquery, it also complains:
Code:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'BoUser'.


Exact same result with WRC. Any ideas?

_________________
Regards,

Chaz
Back to top
charlie
Forum Associate
Forum Associate



Joined: 20 Aug 2002

Posts: 806
Location: Woodinville, WA USA


flag
PostPosted: Mon Apr 16, 2018 1:25 pm 
Post subject: Re: Issue with @Variable('BOUSER')

Ok, figured out what's happening. Just needed to add quotes around the @Variable('BOUSER')
_________________
Regards,

Chaz
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.0297 seconds using 18 queries. (SQL 0.0028 Parse 0.0009 Other 0.0260)
CCBot/2.0 (http://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