what is the reson to take long time?

building semantic layer
1

I have developed one universe, in which it is taking very long time to parse the objects?Even though ,it is just a table column?

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

2

The possible answers to this are legion. If you do a search here, you will find many threads on the topic.

Is it only one object that is the problem? Is it an unusual object, like having a non-standard datatype (uniqueidentifier, memo)? Is there any chance the object has a reserved word as the name? Does the name of the object contain any special characters?

If it is all objects, have you tried connecting to your database in some other way from the server (e.g., tnsping) to see if it is BOXI-specific? Have you double-checked your connection to make sure it is set up correctly?

Have you talked to your DBA to see if he (or she) might know anything relevant?

Lugh (BOB member since 2009-07-16)

3

Some databases require Designer to execute the query in order to parse. So if the object in question is against a very large table it will take a long time. You might also check the “Thorough Parse” parameter and see how it is set.

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

4

Dave,
Thank You for Your Reply.Can you Please elaborate me how to check"Thorough Parse" and what i need to check the setting in the universe Parameter?

Thank You
Pooja

ktm :us: (BOB member since 2008-11-12)

5

I don’t mean to be rude, but I personally don’t always have time to provide more than hints or direction. Did you try to find it on your own before asking? :wink: The phrase “thorough parse” is indexed in the Designer help and is quite easy to find.

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

6

Hello,
There is no option to make check box for “Through Parse” in Integrity Check.
The last one is cardinality.
Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

7

It’s not part of the Integrity Check, it’s a universe parameter.

Did you search the help file as I suggested? For what it’s worth, the parameter is off by default. Since you don’t know where it is, I doubt that’s your problem. You might try working with your DBA and see if they can help you determine what is going on at the database during the parse process.

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

8

Just in case, it’s under Edit -> Links, then select Parameters in the resulting dialog box. Thorough Parse should be the next to the last parameter listed. Click on it and you can change its value in the Value box.

bkaporch :us: (BOB member since 2008-12-02)

9

Just in case, it’s under Edit -> Links, then select Parameters in the resulting dialog box. Thorough Parse should be the next to the last parameter listed. Click on it and you can change its value in the Value box.

I tried the above mentioned tips it was NO and I changed into “YES” but has no effects.

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)