on 09-16-2008 10:39 PM
Hello,
Am trying to create a model for displaying BI data in the portal.
We have portal and BI properly connected with logon tickets SSO and are also publishing webtemplates to the portal. But creating BI content using VC seems to involve a BI wizard and opening this gives an error that
"WARNING 2005: There are no BI systems defined in portal. In order to use BI integration wizard, you must first define at least one BI system based on the BI XMLA, BI ODBO, BI JDBC, or BI SAP Query Connector"
How to fix this issue .
1)why is the system we are currently using (created in portal sys Landscape)for publishing templates not adequate here ?
2)which type of system should be used here ie java/xml/olap etc?
3)Is this the only way to create Bi content in VC for depolying on portal?
Sorry for too many qns ,but would really appreciate some explanation rather than links.
Landscape: Ep 7.0 , VC 7.0
Thank you
Rgds
Hi,
yes this Error is correct.
Beacuse the Bi system you ahd configured through the portal are done with RFC,JDBC connectors.
But to use a BI syetms in BI integration wizard the type of connector s should be BI XMLA, BI ODBO, BI JDBC, or BI SAP Query Connector.
Solution:
Chnage the type of connector in the portal for the BI sytems to one of the above connector then you are able to see the Systems
See the below link for configuration
http://help.sap.com/saphelp_nw04s/helpdata/en/c2/6ca18a338344c8ae9dae2bb2a407c4/content.htm
http://help.sap.com/saphelp_nw04s/helpdata/en/d0/a6f6dae3224d50abca99051bb6e2b8/frameset.htm
Govindu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Govindu,
Thank you for replying to two queries above .But is the integration wizard the only way to proceed
with creating a model here ,or is there any way we can use the current system that is already in the
portal landscape itself ,But its a r/3 load balancing system ??
Saw in the guide that the wizard was used for BI models,but can we manually drag and drop all elements
for the models too?
Rgds
Thanks for the prompt reply, am trying to use the current load balancing system itself,
I cant find any property for changing the connector as you had specified in the load balancing system
that we have .so am trying the manual approach.
Are there any advantages of using the wizard over the other method?
Also we use the BI portal for publishing our templates and hence the inbuilt saplocalsystem.
How would it be possible to use that one in VC?
Also when I try drill down a query and try dragging a particular view to the iview get an error that says
Error -30005, Cannot create the BI data service, Cannot add BI data service to the iView.
Any ideas ?
Rgds
Hi all,
Managed to get around this, but now facing another one.
Trying to add buttons for excel,pdf export using the web API functionality as per the help doc.
The problem is the generated file ie excel/pdf is empty without any data
It only has the following
Last Data Update:
Display As
To adjust filter area, drag characteristics from navigation area into filter area
ADS is properly configured because pdf functionality works through the portal.
Have been following this on another similar thread,but cant seem to get this work.
Any help would be very much appreciated.
Rgds
Hi Vineeth,
I've sent you an email with screen shots on how incorporated a work around. Please let me know if you have any questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Andrew,
Havent received ur mail yet. Meanwhile could you tell me if this is what you did .
Created an info form from the service and reptname as the input field .Then passed @reptname to the data store from the form as the assigned value. The problem is the query name doesnt come in the url even this way.As per the hyperlink of the web API it is supposed to ,but it just opens the analyser and then the blank doc.
Now I get the query name in the url ,but yet the same result with no data.
Please correct me if I am wrong.
Thank You
Rgds
Andrew,
Thanks a lot, There was some problem with our server because this works when i try from
my dev box. Another thing is that this only exports data. I was looking forward to export even
charts into a pdf for printing ,but that doesnt seem possible here ,or does it?
This seems to be a limitation because i have not been able to find anything here
for exporting charts , Have you tried that ?
Thank you
Rgds
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.