Question:
Hello everyone,
I have a query and for the most part the query is running fine. But recently within the query one of the fields is not populating. I have checked the loads, they are fine..
The field has been populating all the while, but suddenly the field (Number) is not populating. Any ideas on what this could be?
Thanks,
Answer:
But recently within the query one of the fields is not populating.
why should this field be populated in the query? fields are normally populated in an InfoProvider... so I assume you're talking about a formula or a calculated key figure or a restricted key figure.
which one is it? and what are you trying to achieve?
cheers,
El Belgio
Answer:
El Belgio,
Guess I wasn't being clear. I am a field that normally shows values in that field. For instance, date, item category, product number all show values in the query, but Equip number, does not show any values in that field. When I check the cube, data is populated within the cube and valid data exists for Equip Num. It seems to be a query problem, so I wasn't sure, what the problem might be. I went to the TC (RSRT) and made sure Caching was turned to inactive, just to see if that posed a problem..again no luck? Any ideas? Your help would be very valuable..
Thanks.
Answer:
Hi,
Try to use transaction /$sync and open again the Bex.
mathieu
Answer:
mathieu,
I tried TC $SYNC, which reset the buffers and I was still unable to see the field with values. Thanks for the hint...but still no cigar!
Thanks...
Answer:
Another weird addition the problem. When I restrict the equip number to a few known numbers, then when I run the query, the equip number field is populated with those values which were restricted...But when I take the filter off, no values show up..WEIRD!! Any ideas??
THanks.
Answer:
midnite,
What does the field show? does it show #, that means it's not receiving any data.
It could be blank because of repeated values not being shown, this can be turned on in query properties.
Answer:
Hey BeW.
No values show up, nothing, the field is completely empty, no #, $, %, nothing. I did try what you said, by turning on show repeated values, but again no luck. Any other ideas?
Thanks guys!
Answer:
Are you using the correct infoobject? Also, in Query Designer, locate your InfoObject and check if it has any values coming in.
Answer:
Hi,
Try to use transaction /$sync and open again the Bex.
mathieu
mathieu,
I tried TC $SYNC, which reset the buffers and I was still unable to see the field with values. Thanks for the hint...but still no cigar!
Thanks...
Don't be free and easy with /$sync. This will also reset any process that may be running at that time, and GOK what will happen!
_________________
Keep smiling
Answer:
I presume that this is a master data characteristic. Did you check the definitions in the BEx tab of the characteristic? There are several settings there like Query Def. filter values selection etc. By default, they should be 'Values in Master Data table', but if by mistake it is selected as 'Values in InfoProvider' then probably the transaction will only show description but no number (Code). Of course you see values when you restrict, because of the last option which takes only 'Posted values for navigation'.
_________________
Keep smiling
Answer:
SR, thanks for the tip on TC $SYNC, I actually read a little more about it, before I decided to use it. But I checked the query and the in the designer, the values are not just from the the InfoProvider. That is why this is so puzzling! But thanks for your input, if you guys can think of anything else, please do let me know. I'm going to do my own digging until then.