It was not possible to retrieve the facets and their values in Explorer

[former_member182918]

Hi All,

Error:-

It was not possible to retrieve the facets and their values. Can't start exploring the information space as it doesn't contain any data. (PS 50011)

I was able to pull the same data from HANA in Webi but in Explorer i am unable to pull the data as i getting the following error.

Any suggestions is helpful

Thanks and Regards

Karthik Kumar C V

[former_member207052 · Accepted solution]

Do you see any errors/warning when you try to "Validate" the explorer infospace ?

Regards,

Naras

[former_member182918 · Accepted solution]

Hi Narashimman,

That is the only error is am able to see.....

I am able to to view data in another report in explorer but for this report i am unable to see the data.

I am attaching the screen shot for the following error.

Back end is hana and also variables are being used as prompts for the report.

Similar view with prompts are working in Explorer but for this particular report i am unable to view.

Thanks and Regards

Karthik Kumar C V

[former_member207052 · Accepted solution]

what I meant was Go to "manage Infospace" -> and then open the Infospace for editing and then click on "Validate" and check if you get any errors.

What is the version of the your explorer installation?

Possibilities:

1. There is/are  mandatory prompt(s) in the view you are using and because it is null you don't see data.
2. Your personalization has some problems.
3. If both of the above has no issues, Try creating a simple info-space with couple of objects based on the same view and check if works. (remote possibility but may be something went wrong with your current Infospace)

[former_member182918 · Accepted solution]

Hi Narashimman K S,

Thanks for the Info,the problem was with the prompts where the value wasn't being passed correctly and that caused the error.

I have rectified it and the report is working fine.

Thank you for the valuable information you shared across.

Thanks and Regards

Karthik Kumar C V

[former_member207052 · Accepted solution]

I had done the samething in the psat. Learning from my own mistakes.

If your issue is fully resolved close this thread.

[Former Member · Accepted solution]

Hi ,

I too got the same bug where when i was doing analysis operation with TA_TOKENs i get this issue.

Too frustrated ,All the sql queries got executed and why it shows sql errors.

Please help.

I created a table than created indexes and no errors.

i have data in the indexes too.but stem was ? and few others were ?

but its fine,

"cannot get facet values error sap dbtech:... sql syntax error "

/Gabriel

[Former Member · Accepted solution]

Wow ... finally solved this issue..

this issue was due to the obsolete version of the hana studio and i tried with eclipse  it did work .

so cool.

My mistakes are solved by myself.

/Gabriel.