Answer / ravikumar sajja

You can change supervisor passoward first using below steps
and then change all the users passwords using supervisor.

Warning: Direct manipulation of the repository tables can
cause damage to your repository and will void your support
contract. Do so at your own risk.

If you don't have a second general supervisor, you could
try the following SQL run against the security domain
database:
Code:
Update OBJ_M_ACTOR
Set M_ACTOR_C_PASSWORD = NULL
Where M_ACTOR_C_NAME = <username of general supervisor>;


This will set the password for the general supervisor to
null, and therefore the next time you login, you will not
need to enter a password. It is recommended that a password
is given asap via the supervisor module.

You will also have to set the status of the user login,
otherwise even with a null password BusObj will not let you
log in.

The status column is in OBJ_M_ACTOR and is called
M_ACTOR_N_STATUS. If you set this flag to 1 along with
setting the password to null then you should be okay. If
this still doesn't work, make sure you have commited the
database update

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 Answers  

---

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers  

---

Explain about Short cut join?

2 Answers   Wipro,

---

What is mean by tuning the report?

1 Answers  

---

Explain difference between zabo and webi?

0 Answers  

---

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,

---

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

1 Answers   HCL,

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  

---

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  

---

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 Answers  

---

What is pragma?

1 Answers  

---

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

---