Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Smartlist default Value

Leo27Jul 31 2012 — edited Jul 31 2012

Hi,

I have a member "Asset Status" which uses a smart list with three values: Inactive, New and Active with the ID's: -1, 0, and 1 respectively. Everything works as expected. But the issue i have is that - i want to cell value to default to "Active". So if i perform a excel retreive, i want to see the value of 1.

I have tried using the #Missing Drop Down label but that works only partially i.e. i can the "Active" populated in the cell but when i perform the essbase retrival, there is no data there. When i manually select Active and save the webform then i can see 1 in essbase retrevial.

So wondering, if there is any way where i can have the cell value default to "Active", so i can hide this column or make it read only to the users disabling them from selecting any other dropdown option.

Using V 11.1.1.3.

Regards
Leo

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2012

Added on Jul 31 2012

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

3 comments

564 views