Views are an easy way for non-SQL people to get data directly from the database (that is, without use of a presentation layer).
They're also helpful for DBAs and data analysts since they can save keystrokes.
You should use joins instead of views. Views bypass the query optimizer and therefore execute slower than joined queries (which can take advantage of statistics).
-Curt.
Can anyone confirm if VBA 6.3 is or is not available to European MS Office users?
Microsoft's worldwide VBA site (http://www.microsoft.com/europe/vba/) implies that only 6.0 is available.
Thanks,
Curt.
1) You are correct. Each table can have only 1 clustered index.
2) You can create Clustered /non clustered indexes by using the "Create Index" wizard (I beleive the clustered/non option is on the 3rd screen), or via the "Manage Index / Keys" screen of the table designer...
Sri,
In response to your questions...
1) The user is the same for WI and Biz Objects
2) All the reports follow the pattern I described. That is, they work from Biz Obj, but not on Web I
3) There are no restrictions on the user
4) The prompt is straight text, not date / time
Thanks.
I have a report that displays the appropriate data when run from the BusinessObjects client application on my local machine. However, when I publish the report to Web Intelligence, the report does not return any data. The user prompt is displaying the correct "choices", so I know...
Hi team. I'm new to Biz Objects, so this may be an easy (that is, stupid) question. If so, sorry!
I'm working with a marketing database that tracks the status of contacts. That is, are they "prospects", "current clients", etc. The database does not track history. When a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.