Categories Uncategorized Americas Summer Workshops 2014 – Analytics April 1, 2014 | 15 Views | Former Member Training analyticsua blogsua eventsua newsUniversity Alliances share share tweet share Follow Hello All, This is the discussion thread for the Americas Summer Workshop 2014 – Analytics. Click here to download and print your workshop exercises. Click here to download the power point slides for the class. Regards, Alex Alert Moderator To report this post you need to login first. 33 Replies 33 Comments You must be Logged on to comment or reply to a post. Former Member May 23, 2014 at 8:33 pm I am excited to see all the participants at the workshop in Chico. We will post the workshop materials on this thread soon. Please post any questions you have about the workshop (before as well as after the workshop). Also enable email notification (on the right side) so that you can be notified whenever there is activity on this thread. See you soon! Nitin Kale like (0) Former Member May 28, 2014 at 7:25 pm Nitin, It sounds like we don’t need to use our own laptops. I still have my laptop configured from the curriculum congress workshop. If we want to use our own laptops, can we, and can we use the same configuration from the March workshop? Also, do you have a draft table of contents for your upcoming book? I would like to align a class I am developing with chapters in your book. I’m really looking forward to the workshop. Thanks, Bill Cantor Penn State like (0) Former Member May 29, 2014 at 10:19 pm Bill, You can use your own laptop. There are some additional software configuration steps required for the summer workshop. There are additional software installations required as well. In the workshop materials linked above, please find the file for Software Installation and go through the instructions for preparing your laptop. I will share the ToC when I see you in Chico. like (0) Former Member June 3, 2014 at 5:59 pm Nitin, I went through your documents for the workshop, and I am very excited to attend. There are a lot of topics and documents, which specific documents do we need to print for the workshop? Thanks, Ingrid Buckley Tuskegee University like (0) Former Member June 3, 2014 at 6:11 pm Ingrid, Download the zip file linked from download and print your workshop exercises. Then unzip the file. You will see many numbered folders and files. Print all files including the ones within the folders. Assemble them in the numerical order of the file or folder. like (0) Former Member June 5, 2014 at 7:43 pm Nitin, Is folder “05 – SAP BW Data Warehousing” supposed to be empty? I don’t see any file in it in my download. Thanks, Fan Tseng Univ of Alabama in Huntsville like (0) Former Member June 5, 2014 at 8:14 pm Fan, That is correct. Nothing to print for 05- SAP BW Data Warehousing. This will only be a demo. like (0) Former Member October 11, 2014 at 8:07 pm Nitin, I’m hoping you are still monitoring this forum. I’m testing curriculum for a spring class, specifically your Business Intelligence with SAP BusinessObjects Analysis, Edition for Microsoft Office (SAP BusinessObjects Analysis 1.4). I’m working on the Analysis for Excel, step 13f, g (page 10). In this step, while working in Excel, you are to select your BW server. We have a Virtual Lab and when I tried this, there were no selections possible. I thought this may have been a problem with the virtual lab, but I tried this on my laptop that I used during the summer workshop with the exact same result. I seem to remember that it uses the SAPGUI information somehow to load the selections, but I’m not sure. The only thing that I may have done since the summer workshop is update the SAPGUI, but I don’t think that I did. Here is the login info if you need it: System BI5 client 800 userID: CZ1-066 Password: bigdatapsu1 Any help will be greatly appreciated. Bill like (0) Former Member October 11, 2014 at 8:35 pm Bill, You are correct that Analysis pulls the server connection from the same file that SAP GUI does. Check this – go to SAP Logon and see if your BW server is listed there in black (not grey). Grey is the list it pulls from the UCC webservice. Black is when you add it manually. So make sure you have added the BW server connection manually into SAP Logon. Then launch Analysis. You should see the server listed in the systems list. Nitin like (0) Former Member October 11, 2014 at 9:17 pm Nitin, Now I remember…Thanks, it works perfectly. I really appreciate your help and the fact that you answered it so quickly. Bill like (0) Former Member October 11, 2014 at 9:19 pm You are welcome. All of my exercises will be bundled with my book. like (0) Hossam Ali-Hassan December 7, 2014 at 7:18 pm Hi Nitin hope this message finds you well. I am preparing my Analytics course and was wondering if there are any critical or recommended updates/changes to the material we used last June at the workshop in Chico. Do I need from the UCC any SAP clients other than: 1- Business Objects and 2- BW /SEM – BI1 & BI2? for Sam’s Club, Dillards and Tyson Food’s data I need to request an SAP BW server from Arkansas, right? Anything else i need to request in preparation for your exercises? Finally, when will your book be available? thank you and happy holidays Hossam like (0) Former Member December 7, 2014 at 8:22 pm Those are the all the system access you will need. Download the latest versions of the software from your UCC. Here is a new exercise fro SAP Lumira cloud – Introduction to SAP Lumira Cloud Book will be launched at SAP Academic Conference in Spring 15. Happy New Year! Nitin like (0) Hossam Ali-Hassan December 8, 2014 at 1:42 pm Thank you for the prompt reply Nitin. Best regards, Hossam like (0) Hossam Ali-Hassan December 18, 2014 at 1:39 pm Hi Nitin sorry to bother you again, but I was wondering where I can find documentation on creating a GBI InfoCube (or making a copy of an existing one) for my students to access. I need it for my students to create queries in Business Explorer (BEx) Query Designer and then analyze the data in BusinessObjects Analysis (for Excel) like we did at the workshop. I already have a SAP BW / SEM (7.3) – BI1 & BI2 client created by UCC Chico and there are various existing infocubes but I dont want to mess with them. Many thanks, Hossam like (0) Former Member December 18, 2014 at 4:33 pm Hi Hossam, No bother at all. You have three options 1. Usually UCC Chico will make a copy of the master cube for you. Ask them to create a cube for you in the InfoArea(folder) designated for your University. 2. Use the Master Cube. Loging to BW. Then Modeling — DWW — InfoProvider — UA BI Curriuculum – Master Copy. At the end of the infoareas for Universities you will see a cube called MU0R1M. You can use this for building queries. Make sure students don’t edit or delete it! 3. Create your own cube by copying the master cube. You can copy it to your University’s infoarea (just once) or make copies for each individual student into their own infoarea. I will email you the instructions for doing this. Nitin like (0) Hossam Ali-Hassan December 18, 2014 at 5:05 pm Thank you Nitin for the prompt and clear response. like (0) Hossam Ali-Hassan January 20, 2015 at 3:50 pm Hi Nitin hope this message finds you well. i am teaching SAP BO Analysis for Office (Excel) and when my students in the computer lab try to select a data source to connect to the BW server in Chico (where their Bex queries and infocube are stored), they only see one server (a HANA server, which is not the server we need). How can I create a connection, or what kind of file do i need to replace/update to see the connections? It is the computer lab and getting the software re-installed is a bit complicated. thanks Hossam like (0) Former Member January 20, 2015 at 4:17 pm 1. Go to SAP Logon (SAP GUI) 2. Create a New Connection 3. Enter the details of your BW server 4. Close 5. Open Analysis 6. You should find the new server listed as a data source. like (0) Hossam Ali-Hassan January 20, 2015 at 4:24 pm Thanks Nitin What is strange is that with the SAP GUI and with Bex Query designer you see the Belfast link (all connections actually) but not with Analysis. Not sure why! Could Analysis be looking for a separate file? Did we install a wrong version (so only a Hana server connection is showing up)? Thanks Hossam like (0) Former Member January 20, 2015 at 4:26 pm Hossam, Did you add the Belfast connection yourself or was it already there? If it was already there, you need to add a new one manually. like (0) Hossam Ali-Hassan January 20, 2015 at 4:32 pm with the SAP GUI the Belfast connection was there by default along with multiple other connections. It there a way to add a connection just for Analysis? Hossam like (0) Former Member January 20, 2015 at 4:35 pm The instructions are in doc 02- Analytics Servers and Logins. like (0) Hossam Ali-Hassan January 20, 2015 at 4:51 pm I will add a new connection in the GUI and try. Hopefully Analysis would see it. Fingers crossed. thank you for the prompt replies Nitin. Hossam like (0) Hossam Ali-Hassan January 20, 2015 at 7:19 pm Nitin, you were right …as usual 🙂 The Belfast connection showed up in the SAP GUI but it was grayed out! I could connect to it with Bex Query but not with Analysis. A created a duplicate one in the SAP GUI, it did not come out grayed out, and it worked. Thank you again, Hossam like (0) Former Member February 8, 2015 at 6:18 pm Nitin, You had mentioned that the book will be launched at the Curriculum conference in April, which I will attend. Will I be able to use it in the summer (I’m offering an analytics course over the summer)? I would be ok using a draft version. If not, I’m assuming I can use it in the fall? Thanks, Bill like (0) Former Member February 10, 2015 at 7:30 pm Bill, Working on getting the book finished. We may have the draft version for summer. Definitely for Fall. like (0) Denise Duncan March 10, 2015 at 5:29 pm Hi Nitin, Will you have a draft version of your Analytics book available at the SAP Academic conference in April at Tempe, AZ? I would like to use it for my BA course. Thanks, Denise Duncan like (0) Former Member March 14, 2015 at 5:48 am Denise, Still working on it! Plan is to have it for the Fall classes. See you at the conference. like (0) Former Member April 3, 2015 at 2:03 am Nitin, In your ‘SAP Design Studio Exercise 2’, step 11 (Customizing the data source)… This concerns a connection to the uark small Sam’s club dataset. Connection seems fine…was able to load query. In step 11a, the instructions are to ‘Edit initial View’. After about a minute, I get the error: “Failed to instantiate data source. See error log for details” I’ve looked at the logs but there does not seem to be anything helpful. I can provide if they would be helpful to you. The first design studio exercise worked fine, but that was with the UWM BW system. Do you think it may be a uark issue? Any thoughts would be appreciated. If you wanted to try it yourself, you can use these credentials: ES59183 SJ85xz$ system WBI sapprt.walton.uark.edu 01 WBI client 200 Thanks, Bill Cantor like (0) Former Member April 3, 2015 at 2:37 am I found a workaround. Instead of using the query that I created, I just used one that was already there (<GS4><89369>). I just picked one at random that was made for this lab and everything worked. I tried saving this query as another name using a similar naming format and then I got the same error. I’m just having all of the students use the <GS4> query and it seems to work fine. like (0) Former Member April 3, 2015 at 4:37 am Bill, Looks like a permissions issue. Contact Michael Gibbs at UArk to see if your account has authorizations. like (0) Former Member April 7, 2015 at 11:30 pm Michael changed permissions to SAPALL which fixed the problem like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.