tag:blogger.com,1999:blog-7569385167918404048.post1576333481864761301..comments2024-01-11T01:27:26.811-06:00Comments on Oracle BI Blog - EPM, Business Intelligence, and OBIEE: OBI Reports from SAP BW CubeBrian Ferinhttp://www.blogger.com/profile/04248805013232726191noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-7569385167918404048.post-66052882830655112672010-07-07T06:07:16.072-05:002010-07-07T06:07:16.072-05:00Hi Swati,
I'm trying to import SAP Cubes into...Hi Swati,<br /><br />I'm trying to import SAP Cubes into OBIEE. I have retrieved the url from the sap machine and after filling all the credentials in OBIEE Import from Multidimensional option, I am getting error "NQSError 46100 Sax parse failed error expected whitespace" <br /><br />I have also enabled the Cube Section in NQSconfig.ini file. And I have also checked the xMLA service in SAP system. Its working fine. <br /><br />Kindly help me where I am missing. Any help would be really appreciated. <br /><br />ThanksMegh Salgiahttps://www.blogger.com/profile/05415580401234600785noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-41367035890244331152010-04-17T07:24:10.888-05:002010-04-17T07:24:10.888-05:00Dear Ramana,
I followed the same steps, but when ...Dear Ramana,<br /><br />I followed the same steps, but when i open the hierarchy, i cannot see all the levels? I am using OBI EE 10.1.3.4 on top of SAP BW R3.<br /><br />Any advice? I am in a POC, so your prompt response is highly appreciated.<br /><br />Kind Regards,<br />MaisMaisnoreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-40134401497370721352010-02-08T03:22:30.242-06:002010-02-08T03:22:30.242-06:00I have tried to connect SAP BW 7.0 with Patch leve...I have tried to connect SAP BW 7.0 with Patch level 18 to Oracle BIEE 10.1.3.4.0, but after entering the Details in the import Pop-up it is giving error as below.<br /><br />"nQSError:46100 Sax Parser failed with error Expected whitespace."<br /><br />Steps<br />1. Import from MultiDimentional - Provider SAP/BW 3.5/7.0, <br />2) URL : with port - http://ipaddress:port//sap/bw/xml/soap/xmla<br />and <br />URL without port: http://ipaddress//sap/bw/xml/soap/xmla<br /><br />Userid & pwd, but I am getting the same error message.<br /><br />Thanks in Advance<br />Murugan.VAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-1415291563169381902010-01-15T22:15:35.128-06:002010-01-15T22:15:35.128-06:00Ramana,
The credentials mentioned are not the cor...Ramana,<br /><br />The credentials mentioned are not the correct one. Actual measures are different and working fine with SAP BI. I have sent a mail to EmailID in detail..... are there any extra settig to be done from the SAP or OBIEE side..<br /><br />Thanks<br />SumanSuman.obihttps://www.blogger.com/profile/16011381526615160584noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-73731799617451372812010-01-15T22:10:22.646-06:002010-01-15T22:10:22.646-06:00Ramana,
Thanks for your promtpt reponse...
actua...Ramana, <br />Thanks for your promtpt reponse... <br />actually my question was should i make any changes in SAP or OBIEE side to get it fixed. <br />because as you said iam using the username/PW in SAP thats working fine. The Error i got is mentioning about some issue with some XMLA fine Error...iam not sure..<br />I have sent you an mail to your Gamil Account in detial... Let mekwno if you need anymore information on this...<br /><br /><br />Thanks <br />SumanSuman.obihttps://www.blogger.com/profile/16011381526615160584noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-31889138171861510222010-01-15T19:36:01.643-06:002010-01-15T19:36:01.643-06:00Suman,
Can you try by using differnt login credent...Suman,<br />Can you try by using differnt login credentials like a user/pw without any space in that. I dont see any issue with the URLRamana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-86859185624185920822010-01-04T08:14:12.778-06:002010-01-04T08:14:12.778-06:00Hi ALL,
i have posted the same ? in the same foru...Hi ALL,<br /><br />i have posted the same ? in the same forum but none repsponded, so i taught of asking you ...Dont mind... i taught of asking in specific to U.<br />because that u aer working on SAP OBIEE....<br /><br /><br />I have tried to import SAP BI Cubes to OBIEE, but after entering the Details in the import Pop-up it is giving error as below.<br /><br />"nQSError:46100 Sax Parser failed with error Expected whitespace."<br /><br />THE DETAILED ERROR, as per my investigatation:<br />46100 Sax Parser failed with error @1%ls.<br />*Cause.* Sax xml parser encounters a problem as described in the error string.<br />*Response.* Please check to see if the syntax of the xml file passed in for<br /><br />The login credentials given at the time of importing are.<br /><br />provider type: SAP BW/BI<br />URL: http://domain:port/sap/bw/xml/soap/xmla<br />Username = about your BW user<br />Password = about your BW user<br /><br />but when i checked, For BW system, with transaction SE37 and execute the function module RSBB_URL_PREFIX_GET.<br />the following values for the import parameters of the function module:<br /><br />I_HANDLERCLASS = CL_RS.............................<br />I_PROTOCOL = (it is blank here)<br />I_MESSAGESERVER =<br /><br />Should i change my URL mentioned, I dont think so as i followed the sytax. corret me if iam wrong...<br /><br />i have enabled the SAP CUBE section in OBIEE @ nqsconfig file. and As per the Error, "nQSError:46100 Sax Parser failed with error Expected whitespace." should i change any other file on OBIEE or make any changes in SAP BI.<br /><br />what is the error cause, had anyone experienced this error. let me know if i skip somethingg...<br /><br />this is an Show Stopper.....<br /><br /><br />THANKS IN ADVANCE..<br /><br /><br />SUMANSuman.obihttps://www.blogger.com/profile/16011381526615160584noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-29377817868780926112009-12-01T13:25:57.397-06:002009-12-01T13:25:57.397-06:00I have not validated this but yes if the case bein...I have not validated this but yes if the case being the MOLAP source structure. Its all about importing the MOLAP structures into OBI physical layerRamana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-83462348130351859312009-11-25T10:22:21.066-06:002009-11-25T10:22:21.066-06:00Do you know if this approach for connecting OBIEE ...Do you know if this approach for connecting OBIEE to SAP BW will exploite the BW accelerator?Unknownhttps://www.blogger.com/profile/02327791045273917087noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-53579280961387393792009-11-09T10:06:27.609-06:002009-11-09T10:06:27.609-06:00Unfortunately there is no documented material from...Unfortunately there is no documented material from Oracle specific to OBIEE with SAPBW. The steps that I have indicated are at high level to import SAP MOLAP blocks into OBI physical layer. Well after that you need to implement the data model design based of business requirements and configure the rpdRamana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-19409657869743453082009-11-07T19:03:24.761-06:002009-11-07T19:03:24.761-06:00Hi
Nice to meet you on web
I am working on OBIEE a...Hi<br />Nice to meet you on web<br />I am working on OBIEE as source from SAP BW which is on Oracle Database<br />Can you please provide me some information like Notes or documentation or material on OBIEE W/ SAP BW <br /><br />Thank youRakeshhttps://www.blogger.com/profile/17724322727574948004noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-29557158218293486082009-10-06T10:58:24.155-05:002009-10-06T10:58:24.155-05:00Michael,
OBIEE treats attributes as dimensions. I...Michael,<br /><br />OBIEE treats attributes as dimensions. I am not sure what is the issue that you have with it. Did you get an error while creating a request with some columns of these attribute. if not please send me a screen shot of the issueRamana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-90168247673864793582009-10-05T13:38:14.945-05:002009-10-05T13:38:14.945-05:00I have been able to connect to and import into OBI...I have been able to connect to and import into OBIEE from a SSAS 2008 cube - but there are issues. The attributes are actually imported as dimensions. Is there a setting that I may have missed in OBIEE? Has anyone experienced this before?<br /><br />Thank you for your time.<br /><br />Michael R.Michael R.https://www.blogger.com/profile/08881034679061384570noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-53662590178188823502009-09-14T09:07:55.682-05:002009-09-14T09:07:55.682-05:00OBIEE needs repository changes to accomplish this....OBIEE needs repository changes to accomplish this. The BMM layer needs to be modeled to handle the values for Units, Currency Codes.<br />The data is through seperate dimension columns for Units and Currency. So the report will have a seperate columns for Units, Currency.Ramana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-25141219521836306702009-09-07T23:28:09.676-05:002009-09-07T23:28:09.676-05:00In case of SAP BW each fact data (Value) is associ...In case of SAP BW each fact data (Value) is associated with a unit may be Quantity or Currency which gets reflected when we pull reports in Bex Analyzer.<br /><br />In case of OBIEE how do I associate the same? <br />Eg. 100 INR, 2 USD. Ideally this should be shown when we use the KeyFigures in the report.Swatiiihttps://www.blogger.com/profile/00217953206558436024noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-68139059677611708422009-09-01T11:10:47.197-05:002009-09-01T11:10:47.197-05:00Good to know that the issue was resolved by settin...Good to know that the issue was resolved by setting the aggregation for metrics. Please let me know in case you have any more questions for OBI Data Modeling.<br /><br />Well regarding the infocubes I believe that this is based of the characteristic values set for hierarchy,data granularity. In OBI model this is handled by Dimensional Hierarchy modeling to address navigation of data from low level of hierarchy to top level.Ramana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-37273500493408380942009-09-01T03:18:31.910-05:002009-09-01T03:18:31.910-05:00How are the infoobjects declared as navigational a...How are the infoobjects declared as navigational attributes for the infocube handled in OBIEE?Swatiiihttps://www.blogger.com/profile/00217953206558436024noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-58064089283539981162009-09-01T02:18:11.374-05:002009-09-01T02:18:11.374-05:00Thank you so much. I am able to retrieve data from...Thank you so much. I am able to retrieve data from the cube. The issue was with the aggregation in the metrics.<br /><br />Thank you for all the support.Swatiiihttps://www.blogger.com/profile/00217953206558436024noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-9586407621128487222009-08-25T17:58:44.147-05:002009-08-25T17:58:44.147-05:00I can understand and I honor any organization poli...I can understand and I honor any organization policy. I thought that it was a POC that you were working on.Unfortunately this is a very generic error and to nail this down you may have to run a simple request which you did already.Please try running the logical SQL directly on the database and check if it returns errors. I have asked you to set aggregation like Sum, Count.. on metrics. I hope it works. Also can you create a simple rpd with data sets of smaller cube. Build a good logical star of that and try validating with a small request filtered to bring in less number of rows of data.Ramana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-88391607205026632032009-08-24T23:35:50.325-05:002009-08-24T23:35:50.325-05:00I have set up filters for a particular Month and M...I have set up filters for a particular Month and Material but i still get the error. We do have complex joins but no aggregates. I will not be able to share the rpd as per our policies. Hope you understand. <br />However i have been trying out with the joins but no luck.Swatiiihttps://www.blogger.com/profile/00217953206558436024noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-6075498916361994192009-08-19T10:44:40.185-05:002009-08-19T10:44:40.185-05:00Did you try setting up a valid filter criteria to ...Did you try setting up a valid filter criteria to any attribute that constrains the data. Also I may have to look at the rpd.Can you mail me the rpd with password.You must have complex joins and also set aggregation to metrics.Ramana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-80589217463697355162009-08-19T00:44:24.515-05:002009-08-19T00:44:24.515-05:00We are testing this with Administrator only. There...We are testing this with Administrator only. There are no complex joins.Following is the log with Vendor as attribute and two Measures.<br />-------------------- SQL Request:<br />SET VARIABLE QUERY_SRC_CD='Report';SELECT Vendor."Vendor Level 01" saw_0, Metrics."Invoice amount: Returns" saw_1, Metrics."Net purchase order value" saw_2 FROM MM_PUR_C01 ORDER BY saw_0<br />-------------------- Logical Request (before navigation):<br />RqList <br /> Vendor.Vendor Level 01 as c1 GB,<br /> Invoice amount: Returns:[DAggr(Metrics.Invoice amount: Returns by [ Vendor.Vendor Level 00, Vendor.Vendor Level 01] )] as c2 GB,<br /> Net purchase order value:[DAggr(Metrics.Net purchase order value by [ Vendor.Vendor Level 00, Vendor.Vendor Level 01] )] as c3 GB,<br /> Vendor.Vendor Level 00 as c4 GB<br />OrderBy: c1 asc<br />-------------------- Execution plan:<br />RqList <<33725>> [for database 0:0,0]<br /> D1.c1 as c1 [for database 0:0,0],<br /> D1.c2 as c2 [for database 0:0,0],<br /> D1.c3 as c3 [for database 0:0,0]<br />Child Nodes (RqJoinSpec): <<33736>> [for database 0:0,0]<br /> (<br /> Child Nodes (RqCache): <br /> RqList <<33708>> [for database 0:0,0]<br /> D1.c1 as c1 [for database 0:0,0],<br /> D1.c2 as c2 [for database 0:0,0],<br /> D1.c3 as c3 [for database 0:0,0],<br /> D1.c4 as c4 [for database 0:0,0]<br /> Child Nodes (RqJoinSpec): <<33721>> [for database 0:0,0]<br /> (<br /> RqList <<33667>> [for database 3023:32063:$INFOCUBE,43]<br /> $0PUR_C01.Vendor Level 01 as c1 GB [for database 3023:32063,43],<br /> sum($0PUR_C01.Invoice amount: Returns by [ $0PUR_C01.Vendor Level 00, $0PUR_C01.Vendor Level 01] ) as c2 GB [for database 3023:32063,43],<br /> sum($0PUR_C01.Net purchase order value by [ $0PUR_C01.Vendor Level 00, $0PUR_C01.Vendor Level 01] ) as c3 GB [for database 3023:32063,43],<br /> $0PUR_C01.Vendor Level 00 as c4 GB [for database 3023:32063,43]<br /> Child Nodes (RqJoinSpec): <<33689>> [for database 3023:32063:$INFOCUBE,43]<br /> $0PUR_C01 T32096<br /> GroupBy: [ $0PUR_C01.Vendor Level 00, $0PUR_C01.Vendor Level 01] [for database 3023:32063,43]<br /> ) as D1<br /> OrderBy: c1 asc [for database 0:0,0]<br /> ) as D1<br />OrderBy: c1 asc [for database 0:0,0]<br />-------------------- Sending query to database named $INFOCUBE (id: <<33667>>):<br />With <br /> set [0VENDOR1] as '{[0VENDOR].[LEVEL00].members}'<br /> set [0VENDOR2] as ' hierarchize ({ [0VENDOR1], Generate({[0VENDOR1]},Descendants([0VENDOR].currentmember,[0VENDOR].[LEVEL01],SELF), ALL) } )'<br />set [Axis1Set] as '{[0VENDOR2]}'<br />member [Measures].[MS1] as '[Measures].[0IR_VAL_RET]'<br />member [Measures].[MS2] as '[Measures].[0NET_PO_VAL]'<br /><br />select <br />{[Measures].[MS1],[Measures].[MS2]} on columns,<br /> NON EMPTY {[Axis1Set]}properties MEMBER_UNIQUE_NAME, PARENT_UNIQUE_NAME on rows <br />from <br />[$0PUR_C01]Swatiiihttps://www.blogger.com/profile/00217953206558436024noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-90365718657909464922009-08-11T09:20:28.692-05:002009-08-11T09:20:28.692-05:00This is a generic error and is not due to data siz...This is a generic error and is not due to data size. Did you test this effort as an Administrator, Can you increase the log level to 7 and send me the logical query from Manage Sessions. Also can you check on the complex joins within the BMM layer for the star. <br />Try with few columns like 1-2 attribs and 1 measure and let me know if there are resultsRamana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-6118945762696714662009-08-11T00:31:17.647-05:002009-08-11T00:31:17.647-05:00We have not done any changes with respect to the j...We have not done any changes with respect to the joins. We have just dragged and dropped the Cube from Physical layer to Business and Presentation layer.<br /><br />Could this error be related to the volume of data? We have huge data in the cube.Swatiiihttps://www.blogger.com/profile/00217953206558436024noreply@blogger.comtag:blogger.com,1999:blog-7569385167918404048.post-82175055848219635912009-08-07T08:47:27.721-05:002009-08-07T08:47:27.721-05:00I believe like this is got to do with the selected...I believe like this is got to do with the selected column and underlying logical model. Are these columns selected from a single star. Let me know the star details beacuse as per the error it indicates a missing attribute but I see that there are couple of attrib columns selected.Ramana Chittoorhttps://www.blogger.com/profile/05011884994855531549noreply@blogger.com