Skip to Content
avatar image
Former Member

Bex Query Char Restriction on Fiscal Year (0FISCYEAR)

Hi,

On a particular DSO with hourly data loads and SID Generation during activation setting, When I try to create or execute a query I am having  issue with Fiscal Year (0FISCYEAR)

Query Execution Issue:

I have a mandatory user selection on Fiscal Year (0FISCYEAR),Upon the dropdown box display of Fiscal Year (0FISCYEAR) to display the list of
values systems is taking too much time and giving me time out error

Query Creating Issue:

When I try to create a query with char restriction on  Fiscal Year (0FISCYEAR),again to display either single values or list of avaliable variable or value ranges the system is taking too much time and time out issue.

This is happening only on this DSO and Fiscal Year (0FISCYEAR) used in rest of the cubes/dso’s is working as expected….

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 15, 2014 at 03:35 PM

    Few suggestions:

    Is fiscal year a part of keyfield in DSO ?

    If not then try creating secondary index on fiscal year and see if that reduces the time or not.

    Regards,

    AL

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 16, 2014 at 06:56 AM

    Hi,

    I had similiar problem some time ago : values of characteristics loaded without and.

    It appeared that version of BEx was slightly old.

    After updating BEx version to BI Add On 7.X (based on 7.30) SP 7 Rev. 734 BEx works ok.

    Regards, Leszek

    Add comment
    10|10000 characters needed characters exceeded