Hierarchies in universe build over a flat file

[Former Member]

Hi,

I have buit a universe over a flat file which has a single table consisting of all the data(Dimenssions and Measures).

When I built a WebI report over that universe the drill button in the report pannel is showing as dissabled.

Even though I define a custom hierarchy in Universe Designer, it is the same case.

So, Is it possible to have hierarchies in universes that are built over flat files?

If yes, how is it done?

Thanks,

Viswanath.

[Former Member]

Was a helpful answer.

[Former Member]

Just check weather you have right on Drilling the report.

You can check right on below location in CMC.

Applications->Web Intelligence->User security->Assign security->Advanced rights->Add/remove rights->Application->Web Intelligence->Enable drill mode

[Former Member]

Hi,

Drill option works fine in WebI. I just tried in my environment. Its working fine.

Probably you need to provide priveleges from CMC.

Check out the properties for WebIntelligence Application.

[ravi_rawat]

Please check the above thread.

Edited by: Ravi Rawat on Apr 8, 2011 8:32 AM