Anyone using out of box Activity Universe BOXI 3.1

building semantic layer
1

Hello,

I was trying to use the default activity universe that comes with BOXI3.1 installation. I have auditing set-up and enabled and i am able to work with the default reports that have been provided.

My biggest concern is that the Activity universe fails basic integrity checks in the Designer . I see some errors w.r.t some of the calculated measures etc.

Has any one faced similar issues? Did you have to modify the universe?

Thanks

ramaks (BOB member since 2009-03-31)

2

Hi,

I faced similar issues with the activity univers after a brand new installation… I contacted the bo tech support, they provided me a new universe which worked well.

Regards

Cedrick

cedrickb :fr: (BOB member since 2005-08-19)

3

Are you sure that you loaded the correct DB version Activity universe for your installation, i.e. it should be the same DB platform as your Audit tables.

Give us an example of the failed components when running an integrity check…

Mak 1 :uk: (BOB member since 2005-01-06)

4

Hey Guys…

thanks for the replies. I use the universe for SQL Server 2005.

This is how i have fixed this

  1. A few measures failed integrity checks… had to add a distinct to their select to fix.

  2. All joins do not have the correct cardinality specified…this is where most of the errors were found. I have used a combination of auto-detect and schema definition to assign these.

So, at this point the universe looks good. However it definitely cannot be used out of the box.

ramaks (BOB member since 2009-03-31)

5

This error can be ignored unless you actually want a distinct, I would suggest you should have left this as it was…

The cardinalities make no difference to the query genarated, but are there for graphical display and to help auto context generation.

I would disagree with this, see points above, I have used it, many many times, as is…:).

Mak 1 :uk: (BOB member since 2005-01-06)