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.

 

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?

thanks for your time krishna.

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. :)

kirshna, looks like it is working. Thanks a lot bro. Sajha Rocks :)

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.

 

the browse button is the "associated dimension", so click on it and associate it with the merged dimension (origfilename) in your case. I think before you didn't do that thats why it gave you data sync error. It was not getting synchronized. Let me know if that works.

kirshna bro, still not seeing the browse button, can you post a screenshot of what your refering too. I have the date figured out. I much appriciate your help

Do one thing, on the Variable Editor box, first you put the name of the variable, then you select its datatype which in your case is 'Detail' then after that it says 'Associated Dimension'. It basically is asking you What is the associated attribute to which it should be a detail of? On the right of that there is a small browse button. Just click on it. And choose the object in your case will be Unique ID that you merged from the first query. Let me know. I can't give you the screenshot right now. If you cannot find it, let me know, and I will send it to you tomorrow.

Krishna bro, thank you so much for your help. Yes I got it to work, I had not seen the browse button becasue it was grayed out, silly me. I appreciate your help. Btw where do u work, do u use lots of business objects?

Ok bro! Glad you got that to work. Ya, I am doing both Universe and WEBI development. Let me know if you need any other help. Good Luck.