June 3, 2008 at 6:53 am
hi,
I had successfuly deployed my first cube and i can browse throught it.I wants the data to be reflected immedieatly on the cube if there are some transaction takes place on database.I came to know we have to enable "proactive caching" for this.Now i had enabled proactive caching enabled for the cube by right clicking partions.Now am trying to browse the cube by assingning rows.It immedieatly throws me a error when i assign a dimension to row.
The error is
The query could not be processed:
o OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.
When i do proactive caching it shows me some notification warning...I could not figure out it...Help me out friends
cheers
vijay
June 13, 2008 at 12:33 am
hi friends,
No body has faced this error..:unsure:
June 23, 2008 at 5:49 am
hi guys,
Tell me whether we need to enable; proactive caching for a cube or not...Whats it for then?:w00t:
June 23, 2008 at 8:31 am
Not quite sure why (maybe the flight recorder?) but your system wants to run a trace. Enable the user (who's on your connection) to do this (see here) and the error should go away.
You could/should use proactive caching when you want to see the results of data changes immediately (or at leats witihin the acceptable threshold you define). If you're going to use it in a PROD environment, you should read up on the various settings and the implications of these so you don't always send users to the source (thrash the source DB) and also don't give them data that's too stale.
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply