DataWarehouse Cube Processing Errors and Issues
We are having issues with Cube Processing within the service manager console. It hasn’t been working for a while and we created a PowerShell script to perform the tasks that the cubes were supposed to be doing and to have our data up to date.
We are trying to resolve this issue but it’s tricky, I was wondering if anyone has any ideas on this and can point me to the right direction.
The Cube obs are listed as failed and when I try and access
the cubes I get access is denied. Within SQL the access works with the same
username and password. All the user roles seem to be correct but I can’t access
the cubes within the console.
I have attached some screenshots if it makes it handy. Our SQL specialist isnt sure why it doesnt work as things from SQL end seem to be fine.
I'm not familiar with how all this connects together but i was wondering if anyone has experienced anything like this before and how they resolved it.
We want to retire the PowerShell script eventually and rely on the cubes to process the data correctly.
Any help will be appreciated.