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: Upcoming Events: BI+Analytics Huntington Beach CA: Feb 21, SAPinsider BI 2018 Vegas: Mar 1.

Unable to report on Universe with removed Schema Name


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



Joined: 12 Feb 2018

Posts: 1



PostPosted: Mon Feb 12, 2018 12:46 pm 
Post subject: Unable to report on Universe with removed Schema Name

We have a universe for reporting on Dynamics & the tables do not have the schema pre-fix

A new computer is encountering problems with reporting on the universe
It doesn't seem to recognise that any of the tables are in the universe and returns an error:
'Exception: DBD, [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.State: 42000'

It appears to be looking for their full table names including schema pre-fix, & can read data if a table is re-added

This is the only computer to encounter this issue, so I'm assuming it's a settings issue

Please can you point me in the right direction?
Thanks
Back to top
jemstar
Forum Associate
Forum Associate



Joined: 30 Mar 2006

Posts: 728
Location: Dublin , Ireland


flag
PostPosted: Mon Feb 12, 2018 12:55 pm 
Post subject: Re: Unable to report on Universe with removed Schema Name

How are you authenticating against the Dynamics database?
_________________
regards,

James

http://www.jemstar.ie/

Available for Contract Work In Ireland (and remote work worldwide)

Expert in Universe Creation directly over Enterprise applications (JDE, BMC Remedy, EBMS, Jira, ArisG, Bespoke, Mercator, RAPID, M3, Movex)
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.0103 seconds using 18 queries. (SQL 0.0036 Parse 0.0002 Other 0.0066)
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