Universe Design using the Excel sheet

building semantic layer
1

Can any help me out in designing the universe using the excel sheet as the Datasource.

Thanks,
Crazy

crazy (BOB member since 2007-08-02)

2

Hi

You cannot use the Excel file to Design your universe.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

3

I believe (s)he wants to use Excel as the data source for a universe, in which case it can be done.

dessa :madagascar: (BOB member since 2004-01-29)

4

Ensure that the following steps are done before inserting a table from Excel sheet into a universe.

  1. Go to Excel and highlight all the cells that you want in the same table.
  2. Go to the Name box from Insert->Name->Define and give a name (in Designer, you see this name as a table of all the values you have selected).
  3. Go to Designer and pop up the table browser. You have to drag and drop the name you gave.

haider :es: (BOB member since 2005-07-18)

5

[Moderator Note: Moving from General Discussion forum to Semantic Layer.]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

6

I am getting the error as Driver not capable:Transactional mode while doing the check integrity.Can you help me out.

Thanks,
Crazy

crazy (BOB member since 2007-08-02)

7

What integrity checking do you expect it to do from an Excel source? It’s not a database… :wink:

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

8

Thanks for your information
Is there any other precautions that has to be taken while designing the universe using the excel sheet and also at report level.

Regards,
Crazy

crazy (BOB member since 2007-08-02)

9

I’ve never done it, but if I were going to try, I’d do a search to find all posts in this Semantic Layer forum that have the keyword Excel and read through them. :wink:

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

10

Digpen has a nice tutotrial on his homepage detailing how you set up Excel as a data source.

Digpen Excel Tutorial

dessa :madagascar: (BOB member since 2004-01-29)

11

yes… its mandatory settings… (like highlights the data and name box naming etc )
however my :hb: trouble in report scheduling …
if my excel will get replaced periodically through scheduling, then each time i need to perform these setting manually…
can we automate these setting … :mrgreen:
if Yes, how… ? if anybody can provide the answer for HOW, that would be great help for me ?

thanks in Advance…

Vills :india: (BOB member since 2007-10-24)