posted valuesu201D in read mode

[shanthi_bhaskar]

Hi Fellow Experts,

We are loading data into Infocube and by doing deleting the overlapping request option..Reports are built upon this cube..we have fiscal period as selection screen varaible. when i press F4 then it brings values from DIMID table rather than fact table so it shows historical fiscal period entries..for which no data exits , i need the fiscal periods which are having transactions in fact table..i after doing some search i found out this link where i can set the POSTED VALUES option in Generic Naviagation block

http://help.sap.com/saphelp_nw04/helpdata/en/1d/499d398b45160ae10000000a11402f/content.htm

But i am not how to set this to only particular queries and i am not using WAD at all.

Please throw some insight on this issue.

Thanks in advance.

shanthi Bhaskar

[shanthi_bhaskar]

any input on this...

[ssurampally]

Hi,

It works fine for me, Have you tried the above procedure given in link ? I am using Bi 7.0.

I have a input ready variable for 0fiscper, in run time, Click on input help tab - Click on Settings tab - Go to value restrictions tab -> Read mode setting -> values in infoprovider

[shanthi_bhaskar]

when i press F4 on fiscper in selectio screen i am not able see settings tab..please guide me

[ssurampally]

In the selection screen, instead of F4 search, Just try to click on the "Select values from list" button. If you do not see this option, might be that I am using some other version.

One question, are you executing the query in Portal or Bex workbook(excel) ?

[shanthi_bhaskar]

i am executing thr portal

Edited by: shanthi bhaskar on May 6, 2010 2:59 PM

[ssurampally]

Hi,

You can select "only posted values" option in the input help settings.

http://help.sap.com/saphelp_nw70/helpdata/en/ae/1e9b3c334d8c15e10000000a114084/frameset.htm