Hi,

I am trying combine two universe so I can get two tables ( each in different universe) and I am getting "table or view doesn't exist" error on the universe i am trying to insert. Any help would be really appricated.

Bro you gotta clarify a little more. So you have two different universes ? Are they both pointing to the same database or different database?  What do you mean by combining? Linking them?? in Reporter?? or you are trying to link two universes based on comon dimensions in Universe itself? Where are you getting that error? In Universe or Reporter??

I have two different database. one is isoft databse, other is gateway databse.

So, What i am trying to do is create a report on infoview. For that I will need to create universe.

First Approach:

Create two seperate universe. One for gateway by itself with necessary tables and other for isoft by itself with necessary tables.So I create a gateway universe and do insert>universe. The universe is inserted but when i click on isoft table and "column values" it says table or view doesnt exist.

Second Approach:

I create two seperate universe and export it. I go to infoview and do "Add query" and import two sepearte universes and drag rq attributes into the Results objects window and go to edit report window so those attributes are available now to compare. I am getting values from both databases but dont know how to link those tables together. isoftfilename from gateway is suppose to match origfilename from isoft.

 I tried it on query filters to make isoftfilename from gateway equal to Object and select origfilename from isoft, but that attribute is not appearing as a choice.

I gues the two databses are not connecting.

I think best approach is just making a universe so that we have both tables from two databases so infoview doesnt get confused, but the first approach (insert>unievrse) is not working.

what i have to do is create a report where i have to have

gateway.isoftfilename=isoft.orginalfilename

then get info from isoft database... to I create 1 universe in designer having both the tables(from different databases)? or create two different universe (isoft and gateway) and combine it in infoview.

How to do each?

First of all, you have to create two different Universe if the tables you are are in two different data bases.

you cannot point same universe to multiple data sources. That means that Universe cannot have multiple connection. Only single connection. So you can only bring tables from one database.

You best bet is to create two universes and merge them together in Infoview.

Create two universe, First Gateway and Second Isoft.

1. Create a query containing objects from Gateway. Click on Add query and add objects from Isoft Universe.

2. Run both queries.

3. Click on Merge Dimensions. You will see two diamond shaped icon on the tool bar.

4. You will see objects from Query 1 and Query 2. If you have  isoftfilename on Query one and orginalfilename on Query 2. Click on both of them and click Merge on the Right.

5. Now you should be able to create a report with both those queries. The problem was that you are not linking or merging the common objects from two queries thereore it is not allowing you to report on multiple universes as they are not compatible when not merged.

Now, regarding your error where it says, 'table or view doesn't exist', it seems to me that you have designer access but donot have atleast a read-only access to the database. Make sure that the database you are trying to use, gives you the right to select tables.

hope that helps.

did that, but how do i access origfilename attribute from isoft databse now?

When i go back to Edit Query of isoft, I drag origfilename to Query filters, I want it so that isoft.origfilename=gateway.isoftfilename

How do i do that?

in the report, i have to show info from both gateway and isoft database. The link is:

gateway.isoftfilename=isoft.origfilename, using isoftfilename i want to extract more data from isoft table.

"in the report, i have to show info from both gateway and isoft database"

As I mentioned earlier, create two different Universes pointing to two different databases gateway and isoft. Then extract the tables in the Universe from the database you just pointed to. You just have to do it seperately for two universes since you can only have one connection per universe. Then from those tables create objects by pulling all the column/attributes you want. Export the two universe after you are done with creating them. Then go to the Infoview and pull whatever you want. If you want it from multiple Universes, then create another query and add the objects. Then you merge the two common objects, in your case it looks like origfilename and isoftfilename, which will then link the two queries. Then you can create a table using all the attributes from the first one, or second one or both.

krishna,

"Then you can create a table using all the attributes from the first one, or second one or both."

I was able to merge the two databases together.. no problem but the thing is, if i go to the isoft query, i am not able to see any attributes from the gateway quary. So I am not able to mix attributes from both tables. I dont have access to it now, I will try again tomorrow. If i still have trouble, hope u will help. You are lifesaver. :)

ok another problem, i am able to get the correct information from the isoft database, but for the gateway database, i am not able to get the correct corresponding info which corresponds to origfilename in isoft. ( i merged isoft with gateway)

Is it because i merged isoft with gateway, so i can only use isoft attributes?

Is there a way to use corresponding attribtes in gateway as well? Thanks again krishna bro.

Bro, do one thing, create 'Detail' objects for all the attributes in your gateway query. Some of them somehow won't be compatible objects on two queries. Therefore, create a variable, add the object, in the variable statement, just you can double click that particular object the one which you are creating a Detail one, change the data type to Detail and on the browse button point it to the gateway unique ID, which is the ID that you merged with your isoft query. Here you saying that the object is a detail of the Unique ID in both common objects in the query. That will create a detail object under variables. You should be able to add that object now in the table.

Hope that helps.

i created a variable, just dragged the attribute I want from Gateway and changed the type to detail. iF I try to put it in a table containing all gateway stuff, it works, but if i put it in a seperate table with isoft stuff, i get #datasync .

It works if i put isoft and gateway attributes in different tables, but we need to put it in same table because the report layout will be messed up.

Also, is there a way to filter out from the list of time, the latest time. I know i have to use variables, but how?

Krishna,

We are looking for Business Objects instructor for ours IT Consulting Company www.vastika.com

Let me know if you know someone who live in Dallas, TX or if you are interested?

kirshna bro,

i have a begin date as 20040721152135, is stored in Begintime variable.... 20040721 is a date, 152135 is time. I want to make a variable such that 20040721 is sepeareted.

=ToDate([Begintime];"yyyyMMdd") but it gives error because we have not spacified in our formula here what 152135 is, how do i make it work.

btw i really appriciate you helping me out with this. I am interning and there is no outside help.

vastika, you might wanna email krishna bro. I am sure he will check back here :D . He seems to know his stuff. Krishna bro, I am still not able to put isoft's attributes on table with gateway's attributes (apart from origfilename because that was doen through merging). I figured out how to sepearate time and date, but now need to figure how how to do the latest time and latest date of EACH record.

Can you help with the table combining problem though.  

Bro, if the field is already in date then you can just do

FormatDate([Begintime];"yyyyMMdd hh:mm:ss") ....let me know if that doesn't work..

Bro..Sorry missed your post on the date thing. Glad you figured out.

Make the 'Detail' on all the attributes from your ISoft query. For example if you have [Name] and its not going in the table, which shows its incompatibility with the other query's columns, you need to create a Variable, Change the Date Type to 'Detail' Object and on the side you will see a little browse button, browse it and click on the first Query's, origfilename, which in this case you merged with the second query. Now the new Detail Objects with a diamond shape should be compatible and allow you to put in the table with the first query's attributes.