BusinessObjects Board

Using EFashion for Training

building reports desktopintelligence
#10

They would go into the Control Panel - ODBC Connections, and create the connect there, just like you would in Designer or Supervisor.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#11

Hmmmm. Ok, she did that, and we confirmed over the phone together that our settings are the same, and still getting the connection unavailable message. Again, so much for Zero Admin!! (or at least training anyone who’s a ZABO user!) Any other thoughts?

Also (just adding this a couple minutes after my original posting) — when I, as a user, try to use the eFashion universe via my webi connection (rather than BOMain) I get the same message (DA0004…). So maybe there is something I need to do on the server? Or somehow define the connection differently in Supervisor?

Thanks!

Amy Miller :us: (BOB member since 2002-06-07)

#12

If you’re going to use eFashion via ZABO, then the database and the definition of the connection need to be on the server. The easiest way to do that is to create a secured connection for eFashion (which you need to do if you’re exporting the database anyway). But the DSN (data source name) that you use from the list of ODBC data sources must be defined on the server.

That’s where the “zero admin” part comes in… you define the connection one time (on the server) and everyone can use the file, even if they don’t have the connectivity installed on their workstation. See, you knew that the “zero” part had to be there somewhere… :wink:

If you are using eFashion in full client, then the connection needs to be defined on the workstation.

Dave

Dave Rathbun :us: (BOB member since 2002-06-06)

#13

Are you doing this in ZABO? If so, then the database should be located on the Webi server, not the client. Then open up the universe in Designer on the Webi server, and check the parameters to make sure you have a valid connection defined there. Also, use UNC path for the connection, not a drive mapping.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#14

Ok, hopefully just one more question — we’re using a Unix server. Can I have an Access database stored there? And how in the heck do I set up an ODBC connection on the server, that sees it in the right place? Ick!

Thanks!

Amy Miller :us: (BOB member since 2002-06-07)

#15

Hey all–

Just to close the loop on this – I heard back from Tech Support, and they said that “type of database is not accessible through Web Intelligence on Unix operating systems”, and so, basically, it won’t work. I wrote back and suggested that they remove the Getting Started Guide from the Unix ZABO installs, then, so people won’t go looking for EFashion. :roll_eyes:

Thanks,
–a.

Amy Miller :us: (BOB member since 2002-06-07)

#16

You can still install the eFashion database, drivers, and whatnot on each workstation. It does remove the “Z” from “ZABO” as you observed earlier. :wink:

Dave

Dave Rathbun :us: (BOB member since 2002-06-06)

#17

If I don’t export the universe, where do I put it on my machine so it will be visible in Zabo. I tried the regular ‘Universe’ folder, tried the server key folder, and also tried creating a ‘Universe’ folder under the key folder. Where do I put the darned thing? :wah:

Cindy Clayton :us: (BOB member since 2002-06-11)

#18

I’d like to close the loop on this one. From my reading and testing (albeit limited), it seems that in a ZABO Unix environment it is NOT possible to use a MS Access database (like eFashion, Island Resorts, and so forth).

  1. The Demo Kit is not included in the ZABO installation, but …
  2. The necessary files from the demo kit can be installed manually, but …
  3. A local ODBC connection would also have to be created manually, but …
  4. Using ZABO (by definition) effectively ignores any connections created locally, so …
  5. The demo database can be loaded on the ZABO server, but …
  6. It’s not possible to create an ODBC connection in the Unix environment (need confirmation here).

We have in excess of 2,000 users to train in one portion of our project alone, and there are enough of the “self motivated” among them to justify the effort of recreating eFashion in Oracle, but I wanted to be sure I wasn’t missing something simple.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#19

There are ODBC drivers out there for Unix, I am not sure if it is really worth all the effort and cost to make the efashion universe available though…

Look here for ODBC drivers for Unix from Easysoft

Or look here for ODBC drivers for Unix from DataDirect Technologies

If you do a search on Google you should come up with quite a few results…

Andreas :de: (BOB member since 2002-06-20)

#20

Thanks for the leads. I’m not involved in the server side of things, but at least now I am more informed about what is possible.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#21

I think I have the eFashion universe creation script as an ORACLE set if you want it. I had done the same for the Island Resort Marketing, so it too is a script.

I’d basically exported the data from the Universe to Text/Xls files and turned them into insert statements with Drop/Create Table statements first.

If your “end” database is going to be ORACLE, it’s usually best to teach in Oracle to avoid having to deal with the Universe Formulas being different.

-RM

digpen :us: (BOB member since 2002-08-15)

#22

digpen: if you can zip / email your scripts to bobdownloads@forumtopics.com we can post those for download. Hmmm, the “code samples” forum should perhaps be renamed to “downloadable goodies” forum intead. :wink:

Dave

Dave Rathbun :us: (BOB member since 2002-06-06)

#23

Will do sir!

digpen :us: (BOB member since 2002-08-15)

#24

Script posted here. Discussion on the script should take place in this topic.

BOB Downloads (BOB member since 2003-05-05)

#25

A script that creates the Island Resorts (Club) database has been posted here. Discussion on the script should take place in this topic.

BOB Downloads (BOB member since 2003-05-05)

#26

Okay, I’m trying to figure out what I missed. I created a secured connection for eFashion and exported the universe. In Supervisor I can see the universe is there. The database and DSN are on the WebI server. But when I login to ZABO eFashion doesn’t appear in my list of universes. Have I forgotten something?

Norm Rosen :us: (BOB member since 2002-07-10)

#27

How long did you wait before trying to access it? You have to wait for the login cache to refresh.

Steve Krandel :us: (BOB member since 2002-06-25)

#28

Steve,
You’ve posted that reminder 100 times and I forgot about it. :oops:

Yes, the universe appears in my list now. Thanks.

Norm Rosen :us: (BOB member since 2002-07-10)

#29

Dear BO Users,

efashion universe data posted here: https://bobj-board.org/t/22133
does not match
efashion.mdb Size: 10702848 Date: 2005-04-05
as provided in our (newer) BO XI R2 (SP5) Release.
We did a new convertion of the mdb and you can find the sql statements to
recreate the data in oracle here:
http://bach.wu-wien.ac.at/rfried/load_efashion.sql.zip

Kind Regards,
Roland

rfried (BOB member since 2009-04-20)