0FISCPER no values for 2006

[Former Member]

Hi

I am working with a query at the moment.

When I try to restrict the char. 0FISCPER I only get fixed values from year 2004 and 2005. How do I get the values from 2006?

The query is based on a cube which I loaded recently, so it shouldn't be because the cube does not contain data for 2006.

BR

[Former Member · Accepted solution]

Ji Joe,

I think when you restricting you are taking values only in the infoprovider. uncheck the check box( only values in infoprovider), and you will get all the values available in the infoobject.

Hope this helps.

Srini

[Former Member · Accepted solution]

Hi,

Unfortunately the /BI0/SFISCPER table will not hold the fiscal periods for which there was no record uploaded to any cube (which has 0FISCPER).

So you may need to create a temprory IC and upload the data with your required FISCPER values.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Hari -> If I check the cube by choosing manage -> content -> InfoCube content and choose ex. 001.2006 I get lots of values for my key figures. Is this the correct way to check this?

Srini -> In that way I can choose the other values. I was just wondering why I am not able to see the ones I want to use per default?

Anil -> That might sound like it has something to do with my problem. Can you please elaborate a bit? I am not an expert in this.

Thank you all by the way!

BR

[Former Member]

Hello Joe,

Since 2006 is not available in the cube you are not able to see it but you can type it there and restrict it further.

Hope it helps.

San.

[Former Member]

another stupid silly question..

Did you try the search option at the bottom ( is it only they are not in the view of the list? ).by unchecking the infoprovider option.. just incase if you have not tried..

is 0FISCPER is included in the cube? or is this from any navigational attribute?

regards,

Hari

[Former Member]

Hari -> It is inculded in the cube.

The only values in the list is 2004 and 2005. 2006+ years are only visible if I uncheck the infoprovider option. But why is this? I'm quite sure that the cube contains data for 2006.

[Former Member]

I think the cube does not have 2006 data..

can you please recheck the cube for the selection of 2006 and see if it hits records for the same?

regards,

Hari