Hi,

I have a triggered MOLAP cube.
This cube is automatically updated by AS when the source table change.
everything works fine on this cube, a change is reflected in the next
seconds.

but when I'm using the cube as a linked object in another cube (this second
cube s not real time enable), the change doesn't appear until I reprocess
the "another cube" (to release its cache)

How to release the cache of the parent cube when my real time cube change?

this linked object is designed for a many-to-many relationship.

I have try to change the "Refreshinterval" option of the linked object in my
second cube, but this doesn't change the result.

but what is strange...
I setup the system to not cache byquery, but the cache appear to keep the
value for a specific query.
because if I play in the cube and display more detail, I see the new data,
but the first view (which is the grand total) keep the old value!!!

any idea?

thanks.

Jerome.

This is a known issue... As a temporary workaround until this is fixed you
can use the ClearCache API to clear the cache of the linked measure group.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

thanks.
does the SP1 solve this issue?

if there is no solution for the moment, I'll just move my measure group into
my second cube.
does this solve the issue too?

"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote

No, I don't believe SP1 has this fix.

If you move (copy?) this measure group into your second cube, you will need
to process the MOLAP partitions in both places -- but it should work.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Hi again,

can I execute the "Clearcache" command using an XML/A command?
I'm using the ADOMD.Net 9 to access my cubes from my web pages.

thanks.


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote

Sure. The command would look something like this:

<ClearCache
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Foodmart</DatabaseID>
</Object>
</ClearCache>

You can add more specific Object IDs like CubeID and MeasureGroupID to clear
caches only for a particular measuregroup.

Thanks,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote