Question { Hexaware, 9977 }

1) How can you use slowly changing dimension type 2 in
Universe, Reporting and what would be the build process.
2) How can you identify the users in webintelligence not
using the reports past few months. And delete them.
3) How can you move documents from one environment to other
environment

Answer

2) The auditor in the BO repository XIR2 used to keep a log
for every kind of event/action. So, for that particular
webi report, if there's no information logged in the
auditor table for a long time, then user can delete that
report.