Hi,
We are storing the web server details in a table in the database. We tried using that variable in an open document function in webi report and it is working fine if we are adding the table in the same query.
We are planning to use a separate universe, which will contain only this table. We tried linking the Query 1 from the actual universe to the separate universe using a dummy variable ‘X’ in the custom query. The problem is after doing that, when we are using the open document syntax which worked earlier, it is giving error The object ‘[Line Code]’ in position 117 is incompatible.(WIS 10076).
Below is the open document syntax we are using.
="<a href="+Char(34)+[Url]+“sType=wid&sDocName=TESTWEBIURL_REPORT2&sIDType=InfoObject&lsM”+URLEncode(“LineCode”)+"="+[Line Code]+"" +Char(34)+">"+[Line Code]+""
where [Url] is the variable, which holds the webserver details, which is stored in the table in database
Please suggest on what may be going wrong.
Same incompatible error we faced in deski reports which got resolved by changing the [Url] object to measure by suggestion got from Open Document URL. But same thing is not working in webi.
Thanks!
emyjacob (BOB member since 2006-12-01)