Can't see List of values in WebI reports

[Former Member]

Experts,

Trying to create list of values albeit unable to view list of values when I run the report. Its say 'no values to display'

I'd like to show all the fiscal year/period that are available in the database ..

I'm using information design tool  (Version: 14.0.10.v20140826-1544) and use the below approaches .

First created List of values based on query panel in picture below -

    

Then assign this LOV to the object - I could preview the results when I try from IDT however not showing when I try to run the report.

.

Any thoughts ?

FYI - Web Intelligence version 14.0.10

IDT version 14.0.10

I have two connection in this universe

1. Connection to Business Warehouse ( Connection type: Multisource- enabled)

2. Connection to SQL Database (Connection type: Relational )

Thanks,

[Former Member]

Have you Exported the LOV with Universe and Check in Universe parameters as Enabled Force_Stored_LOV  to  Yes.

Best,

Narendhra

[Former Member]

Hi,

Seems like you are getting this issue at IDT level.

When you export the Business layer and see the prompt values in BI Launchpad, do you face similar issue?

If not, you might have to check if you are using a supported Java version. I have seen similar issue due to incorrect Java version earlier.

Regards,

Yuvraj

[Former Member]

Thanks Yuvraj , frankly tried with updating Java version. Did not help much.

This data is deriving from SAP Business Warehouse .. do you know if there's any limitation  ?

Cheers

[Former Member]

A couple of questions:

1) Do you get any results in WebI when you run an identical query to the one behind the LOV?

2) Does the user executing the query have any security profiles enabled?