eFashion Universe

general discussion
1

Has anyone developed any training using the eFashion Universe? I am using this universe and I can’t seem to get any of the dimensions to work. When I try to run a report with any dimension object, I get an error. Any ideas?

Thanks.

Anonymous (BOB member since 2002-06-06)

2

Sure, use it all the time. But you have to check your ODBC version. If you have a newer machine, the logic in some of the objects is incompatible with the driver. There is an older version of the Microsoft driver on the BusinessObjects cdrom.

What sort of errors are you getting? You could also open the universe in Designer and do an integrity check.

Dave

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

3

Thanks for the reply!

The error I’m getting is:

Error during SQL execution: (DA0003)
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression ‘city’ (or any other dimension) as part of an aggregate function. - 3011

How do I open Business Objects in Designer?

Thanks for your help.

Anonymous (BOB member since 2002-06-06)

4

Hmmm… do you have the Access database (MDB) for eFashion? I.e., do you have a file:

C:\Program Files\Business Objects\Demo\EFASHION.MDB ???

If you are licensed for the Designer module, one of the components within your BusinessObjects program groups (Start - Programs - BusinessObjects 5.1) is Designer.

Anita Craig :us: (BOB member since 2002-06-17)

5

Hi there,

I am encountering the exact same problem with all three of the sample Universes. Could you tell me how I can fix the aggregate problem? I have BusinessObjects 5.1. I also have Designer privileges. The Access driver that I am using on my Windows 2000 pro machine is 4.00.6019.00. I don't have access to the BO installation CD, so I am not sure which driver version they use. I would like to see if there is a way to fix this either with designer or some other means. The error seems to result from a faulty SQL statement, since the group by clause in the SQL statement uses numeric values (i.e. group by 1) instead of the actual tuple name. Any suggestions would be greatly appreciated. BTW, I have Access 2000 installed on this PC.

TIA,

Mitch

christowm (BOB member since 2003-05-15)

6

The sample databases were designed for 3.5, not 4.0. If you had installed an earlier version of MS Office, you got the 3.5 ODBC driver files. If you have an upgrade, you’re still fine. But if you got a fresh install of the later version, no dice.

As far as the group by clause, look in the acc2en.prm file (I think I have the name correct). It will be in the Data Access folder, the ODBC sub-folder. You can open it with any text editor (Notepad, for instance). Find the GROUP_BY_NUM = Y and change it to N instead.

I’m going from memory here, as I don’t have my laptop at the moment. :wink: So you may have to figure out what the exact change should be. I think I’m close.

You can also install the older ODBC driver off of the BusObj cdrom, I believe that you will find that it’s in the microsft folder.

Dave

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

7

Thanks for the information. It turns out that I was missing the acc2en.prm and acc2en.rss files. As soon as I placed these files into the ODBC folder and restarted BO, the reports for the sample universes ran like a charm. Thanks again for your help. It is much appreciated.

Regards,

Mitch

christowm (BOB member since 2003-05-15)

8

You’re welcome. And welcome to BOB. :bob:

Dave

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