Anyone with a good reason BEACH wont show up??
In a cluster environment, one box ( I think I know which one) wont show this universe…
The universe is physically on all the boxes, but if you hit this one, it wont show (after a refresh).
Doing training in half an hour, help!!! (please).
Brent
Listserv Archives (BOB member since 2002-06-25)
Check to see if BEACH has a working connection in Designer. I’ve found cases in the past where a universe without a working connection doesn’t appear in the list of available universes.
George Baranowski
QuadraMed
Listserv Archives (BOB member since 2002-06-25)
Brent wrote;
Anyone with a good reason BEACH wont show up??
In a cluster environment, one box ( I think I know which one) wont show this universe…
The universe is physically on all the boxes, but if you hit this one, it wont show (after a refresh).
Doing training in half an hour, help!!! (please).
Brent
======================================
Is ODBC installed correctly on the offending box? (Since Beach uses ODBC to a Access DB…)
John Crowe
Compucom Systems Inc.
Listserv Archives (BOB member since 2002-06-25)
The part I cant get is that I can log in and run queries, can run Designer ON the box that Webi doesn’t like.
I don’t know what is different about this box, I am really cornfused.
Brent
Brent wrote;
=====================================
Is ODBC installed correctly on the offending box? (Since Beach uses ODBC to a Access DB…)
John Crowe
Compucom Systems Inc.
Listserv Archives (BOB member since 2002-06-25)
Hi Listers,
I am very desperate and any suggestions will be more than appreciated.
Here’s my company’s situation. We have a production system that is being written to track employees and who their managers are. The system works by having each manager enter the employee numbers of each person that works for him or her. So, if I am Jane Manager, I log in and specify that Jim Anyworker and Bob Myworker work for me. Once this information is entered into the production system, we would like to take this information and produce a report that shows the manager, people that report to him and then drill to show the people that report underneath that person.
So, in effect, we’d like to see the following:
Number of
Subordinates
Mr. A - President 100
Ms. B - Vice President 50
Ms. C - Director 50
Mr. D - Manager 25
G - Employee1 0
H - Employee2 0
Mr. E - Manager 25
Mr. F - Vice President of Operations 50
And so on and so on…
We have created a data warehouse structure that contains a table called Supervisor, along with Employee, Department, and other standard tables. That table is structured with the following fields. The names in parentheses are the abbreviations I’ll use in the email to refer to the fields:
LEVEL_1_EMPLOYEE_ID (L1id)
LEVEL_2_EMPLOYEE_ID (L2id)
LEVEL_2_EMPLOYEE_COUNT (L2CT)
LEVEL_3_EMPLOYEE_ID (L3id)
LEVEL_3_EMPLOYEE_COUNT (L3ct)
LEVEL_4_EMPLOYEE_ID (L4id)
LEVEL_4_EMPLOYEE_COUNT (L4CT)
LEVEL_5_EMPLOYEE_ID (L5id)
LEVEL_5_EMPLOYEE_COUNT (L5ct)
LEVEL_6_EMPLOYEE_ID (L6id)
LEVEL_6_EMPLOYEE_COUNT (L6ct)
LEVEL_7_EMPLOYEE_ID (L7id)
LEVEL_7_EMPLOYEE_COUNT (L7ct)
If I were to populate this table it would look like this:
L1id L2id L2CT L3id L3ct L4id L4CT L5id L5ct L6id L6ct L7id L7ct
4275 4200 36 3568 4 3475 10 3314 10
20854 2
4275 4200 36 3568 4 3475 10 3314 10
42975 2
4275 4200 36 3568 4 3475 10 4031 10
4275 4200 36 3568 4 3475 10 4598 10 3711
4
4275 4200 36 3568 4 3475 10 4598 10
10367 4
4275 4200 36 3568 4 3475 10 4598 10
16253 4
4275 4200 36 3568 4 3475 10 4598 10
42427 4
4275 4200 36 3568 4 3475 10 42160 10
4275 4200 36 3568 4 3475 10 60935 10 3232
4
4275 4200 36 3568 4 3475 10 60935 10
20395 4
4275 4200 36 3568 4 3475 10 60935 10
42791 4
4275 4200 36 3568 4 3475 10 60935 10
42939 4
4275 4200 36 3568 4 3875 10 452 9
17618 2
4275 4200 36 3568 4 3875 10 452 9
42831 2
4275 4200 36 3568 4 3875 10 1281 9
16001 3
4275 4200 36 3568 4 3875 10 1281 9
42564 3
4275 4200 36 3568 4 3875 10 1281 9
42592 3
4275 4200 36 3568 4 3875 10 1654 9 5255
4
4275 4200 36 3568 4 3875 10 1654 9 8242
4
4275 4200 36 3568 4 3875 10 1654 9
24755 4
4275 4200 36 3568 4 3875 10 1654 9
42515 4
4275 4200 36 3568 4 3875 10 2923 9 6141
5
4275 4200 36 3568 4 3875 10 2923 9
16845 5
4275 4200 36 3568 4 3875 10 2923 9
42342 5
4275 75 36 72 17 56 57
4275 75 36 72 17 177 57
4275 75 36 72 17 335 57
4275 75 36 72 17 405 57 3227 20
4275 75 36 72 17 405 57 5511 20
4275 75 36 72 17 405 57 9516 20
4275 75 36 72 17 405 57 10473 20
If I were to read and interpret this, I would get Employee 4275 as the highest level in my organization structure. He’s got 36 people (L2CT) that directly report to him. One of the people that reports to him, Employee 4200, has 4 people (L3CT) that report to him.
The Report would look like this:
Employee: 4275 36 Subordinates
Employee: 4200 4 Subordinates
Employee: 3658 10 Subordinates
Employee: 3475 10 Subordinates
Employee: 4598 4
Subordinates
42160 0
Subordinates
60935 4
Subordinates
And so on… We’d like to be able to drill on this type of report, but we’re not sure how to include these changing counts.
I forgot to mention that we don’t have a set number of levels at the company, so we settled on 7 for the time being because that was the most we currently had in one department.
If anyone has any ideas, please please please respond. We are in the early stages of this project, that we would even change table structures to achieve this report.
Thanks in advance for any suggestions.
Snezana Ogrizovic
Decision Support Specialist
Quad/Graphics - Information Systems Department (414) 566-6163
Listserv Archives (BOB member since 2002-06-25)
I’m really in a quandary with this, so I thought I’d try again and home someone had some, any insight.
Snezana Ogrizovic
Decision Support Specialist
Quad/Graphics - Information Systems Department (414) 566-6163
Hi Listers,
I am very desperate and any suggestions will be more than appreciated.
Here’s my company’s situation. We have a production system that is being written to track employees and who their managers are. The system works by having each manager enter the employee numbers of each person that works for him or her. So, if I am Jane Manager, I log in and specify that Jim Anyworker and Bob Myworker work for me. Once this information is entered into the production system, we would like to take this information and produce a report that shows the manager, people that report to him and then drill to show the people that report underneath that person.
So, in effect, we’d like to see the following:
Number of
Subordinates
Mr. A - President 100
Ms. B - Vice President 50
Ms. C - Director 50
Mr. D - Manager 25
G - Employee1 0
H - Employee2 0
Mr. E - Manager 25
Mr. F - Vice President of Operations 50
And so on and so on…
We have created a data warehouse structure that contains a table called Supervisor, along with Employee, Department, and other standard tables. That table is structured with the following fields. The names in parentheses are the abbreviations I’ll use in the email to refer to the fields:
LEVEL_1_EMPLOYEE_ID (L1id)
LEVEL_2_EMPLOYEE_ID (L2id)
LEVEL_2_EMPLOYEE_COUNT (L2CT)
LEVEL_3_EMPLOYEE_ID (L3id)
LEVEL_3_EMPLOYEE_COUNT (L3ct)
LEVEL_4_EMPLOYEE_ID (L4id)
LEVEL_4_EMPLOYEE_COUNT (L4CT)
LEVEL_5_EMPLOYEE_ID (L5id)
LEVEL_5_EMPLOYEE_COUNT (L5ct)
LEVEL_6_EMPLOYEE_ID (L6id)
LEVEL_6_EMPLOYEE_COUNT (L6ct)
LEVEL_7_EMPLOYEE_ID (L7id)
LEVEL_7_EMPLOYEE_COUNT (L7ct)
If I were to populate this table it would look like this:
L1id L2id L2CT L3id L3ct L4id L4CT L5id L5ct L6id L6ct L7id L7ct
4275 4200 36 3568 4 3475 10 3314 10
20854 2
4275 4200 36 3568 4 3475 10 3314 10
42975 2
4275 4200 36 3568 4 3475 10 4031 10
4275 4200 36 3568 4 3475 10 4598 10 3711
4
4275 4200 36 3568 4 3475 10 4598 10
10367 4
4275 4200 36 3568 4 3475 10 4598 10
16253 4
4275 4200 36 3568 4 3475 10 4598 10
42427 4
4275 4200 36 3568 4 3475 10 42160 10
4275 4200 36 3568 4 3475 10 60935 10 3232
4
4275 4200 36 3568 4 3475 10 60935 10
20395 4
4275 4200 36 3568 4 3475 10 60935 10
42791 4
4275 4200 36 3568 4 3475 10 60935 10
42939 4
4275 4200 36 3568 4 3875 10 452 9
17618 2
4275 4200 36 3568 4 3875 10 452 9
42831 2
4275 4200 36 3568 4 3875 10 1281 9
16001 3
4275 4200 36 3568 4 3875 10 1281 9
42564 3
4275 4200 36 3568 4 3875 10 1281 9
42592 3
4275 4200 36 3568 4 3875 10 1654 9 5255
4
4275 4200 36 3568 4 3875 10 1654 9 8242
4
4275 4200 36 3568 4 3875 10 1654 9
24755 4
4275 4200 36 3568 4 3875 10 1654 9
42515 4
4275 4200 36 3568 4 3875 10 2923 9 6141
5
4275 4200 36 3568 4 3875 10 2923 9
16845 5
4275 4200 36 3568 4 3875 10 2923 9
42342 5
4275 75 36 72 17 56 57
4275 75 36 72 17 177 57
4275 75 36 72 17 335 57
4275 75 36 72 17 405 57 3227 20
4275 75 36 72 17 405 57 5511 20
4275 75 36 72 17 405 57 9516 20
4275 75 36 72 17 405 57 10473 20
If I were to read and interpret this, I would get Employee 4275 as the highest level in my organization structure. He’s got 36 people (L2CT) that directly report to him. One of the people that reports to him, Employee 4200, has 4 people (L3CT) that report to him.
The Report would look like this:
Employee: 4275 36 Subordinates
Employee: 4200 4 Subordinates
Employee: 3658 10 Subordinates
Employee: 3475 10 Subordinates
Employee: 4598 4
Subordinates
42160 0
Subordinates
60935 4
Subordinates
And so on… We’d like to be able to drill on this type of report, but we’re not sure how to include these changing counts.
I forgot to mention that we don’t have a set number of levels at the company, so we settled on 7 for the time being because that was the most we currently had in one department.
If anyone has any ideas, please please please respond. We are in the early stages of this project, that we would even change table structures to achieve this report.
Thanks in advance for any suggestions.
Listserv Archives (BOB member since 2002-06-25)
The idea that jumps out of my mind is to create a parent-child table with diff hierarcy level.
You said you have 7 hierarchy level, so the topmost parent level is one.
Create a table with parent level,parent id,child level and child id and promt for parent level and child level in your report.
Just a quick thought …you can work more on this…
Regards,
Durgesh
Listserv Archives (BOB member since 2002-06-25)
from “Ogrizovic, Snezana” at Jun 12, 2001 09:56:32 AM MIME-Version: 1.0
Snezana wrote:
Here’s my company’s situation. We have a production system that is being written to track employees and who their managers are. The system works by having each manager enter the employee numbers of each person that works for him or her. So, if I am Jane Manager, I log in and specify that Jim Anyworker and Bob Myworker work for me. Once this information is entered into the production system, we would like to take this information and produce a report that shows the manager, people that report to him and then drill to show the people that report underneath that person.
So, in effect, we’d like to see the following:
Number of
Subordinates
Mr. A - President 100
Ms. B - Vice President 50
Ms. C - Director 50
Mr. D - Manager 25
G - Employee1 0
H - Employee2 0
Mr. E - Manager 25
Mr. F - Vice President of Operations 50
If I were to read and interpret this, I would get Employee 4275 as the highest level in my organization structure. He’s got 36 people (L2CT) that directly report to him. One of the people that reports to him, Employee 4200, has 4 people (L3CT) that report to him.
The Report would look like this:
Employee: 4275 36 Subordinates
Employee: 4200 4 Subordinates
Employee: 3658 10 Subordinates
Employee: 3475 10 Subordinates
Employee: 4598 4
Subordinates
42160 0
Subordinates
60935 4
Subordinates
And so on… We’d like to be able to drill on this type of report, but we’re not sure how to include these changing counts.
I forgot to mention that we don’t have a set number of levels at the company, so we settled on 7 for the time being because that was the most we currently had in one department.
Me:
Dave to the rescue again 
. On www.islink.com is a paper Dave gave at a B/O user group conference on Advanced Universe Design. He has a section in there on dealing with hierarchical data. Maybe it will help.
Debbie Kelly
Museum Informatics Project
University of California, Berkeley
dkelly@socrates.berkeley.edu
Listserv Archives (BOB member since 2002-06-25)
The server OS is Windows 2000 SP1 and IIS 5. The clients are all ZABO with mixed OS’s. Some are Windows 95 and some are Windows 2000 Professions SP2. Oracle is our database/repository. The middleware is Oracle Net8. A brand new repository was created for this system. The only full client is our BO Administrator’s machine.
We have the following issues:
BCA errors being received when the client tries to schedule a job with the BCA. We are getting BCA0017, BCA0018, and BCA0019 errors. Rebooting the server corrects the problem for awhile.
This is one of the major problems we are dealing with. When a client refreshes/edits a document, they get “A connection required to refresh this document is unavailable. (DA0004)”. BO Tech Support said this is a know error with Zabo. They had me run CSP128. It did not resolve the problem. In most cases, if they keep trying to refresh, it eventually will. I may take 5 - 10 times before it does. A lot of client frustration with this one.
This is another one of the major problems. We are having to reboot the server at least once a day, sometimes twice a day. It will get to the point where no one can log on. When you click on the LogIn button, IE just keeps trying. I have let it sit for more than 30 minutes and never get an error. BO had me check the Max Users in the Admin tool. It is set for 10000. We only have a total of 32 clients so far. At any given moment, I have never seen more than 12 in at a time. The clients that are currently in BO continue to work fine. They aren’t aware of the problem.
Thanks in Advance
Shallu
Listserv Archives (BOB member since 2002-06-25)
Hi, Shallu.
The BCA errors may be cleared by the same resolution as below…
This is in fact a known error with ZABO, but BO Support is unable to handle it consistently. No CSP to date will fix it. BO Support may also recommend setting the IIS parameter “Application Protection” for the “wi” virtual directory to Medium. Do NOT do this!
You need to set Application Protection to Low. We’ve been working with some major clients, along with BO Support, and this is the only resolution which works.
The resolution above should help. There was also a posting last week about adding “C:\Program Files\Business Objects\Server\System 2.5\bin” to the path.
Let us know how things progress.
Cheers,
Luis Gonzalez
InfoSol Inc.
Listserv Archives (BOB member since 2002-06-25)
What am I missing?
Thanks
Shallu
Listserv Archives (BOB member since 2002-06-25)
Have you checked the users settings in supervisor? There is a Refresh Documents setting
under Documents folder.
Michele
michele.pinti@stdreg.com
Listserv Archives (BOB member since 2002-06-25)
Yes, he has a permission to refresh the documents. And if I log in as him on the other machine then it works. It’s just his machine where the refresh button is greyed out.
Have you checked the users settings in supervisor? There is a
Refresh
Documents setting
under Documents folder.
Michele
michele.pinti@stdreg.com
Listserv Archives (BOB member since 2002-06-25)
Shallu,
Why not try to unstall Zabo and install again on that particular machine?
It may solve your problem.
-Durgesh
Yes, he has a permission to refresh the documents. And if I log in as him on the other machine then it works. It’s just his machine where the refresh button is greyed out.
Have you checked the users settings in supervisor? There is a
Refresh
Documents setting
under Documents folder.
Michele
michele.pinti@stdreg.com
Listserv Archives (BOB member since 2002-06-25)