The Cube with ID = Rate doesn't exist in the collection Error Message

[Former Member]

When doing a Full Optimization in the Rate cube I get a "The Cube with ID = Rate doesn't exist in the collection" error message. What is causing this error and how do I fix it?

[Former Member]

What happens if you click on the rate cube and choose Modify application? Does this process goes right?

[Former Member]

The modify application process does not work either. I posted that problem under a different thread. That error is "Object variable or With block variable not set"

[Former Member]

I have seen this error when reporting services was not properly configured. can you connect to http://servername/reports ?

If not try to fix reporting services first, this solved the problem for me in the past.

But usually in this case all the aplications are giving this error when modifying. Is this also the case in your appset?

Does Apshell work when you modify the application there?

-Joost

[Former Member]

But usually in this case all the aplications are giving this error when modifying. Is this also the case in your appset? No it is only happening in the Rate app

Does Apshell work when you modify the application there? The Rate app works in Apshell

[Former Member]

Can you successfully process all the dimensions in of the rate application? And is there at least one secured dimension in the rate aplication?

-Joost

[Former Member]

I get the same error message if I include the rate app, otherwise they process correctly. I have two secured dimensions in the rate app, set-up the same as in Appshell.

[Former Member]

Was anyone able to solve this issue? I am getting the same problem when I try creating dimensions or processing application - It gives me error - OLAPConnect Error: The Database with ID = 'AppShell' doesn't exist in the collection.

Please let me know.

Thanks,

Ameya Kulkarni

[Former Member]

Hi

Can you check what is your Server Collation setting of your MSSQL Server?

Halomoan