BA Virtual Cube- Shared Dimension

ashbhardwaj

Hi

I have created a Virtual Cube in BA.

How to create a Shared Dimension for there analysis. is some thing to do in SQL Analysis services or from navision setup.

Please help.

Any document on it.????

Thanks

Ashish

vyanku

if you have virtual cube then open that virtual cube in BA for analysis.

ashbhardwaj

Hi
Thanks , but where to define the share dimension in BA

vyanku

What do you mean by shared dimension?

ashbhardwaj

Let me explain more:
What i have done is that, i have created a cube 1 with sales line table & other cube 2 with sales line archive table.
both are working fine .
Now i have created a new virtual cube say SALE with both cube1 & cube2.
So now when i do analysis i have dimension of both sales line & sales line archive.

If i take ex. sales line dimension then Measure with Sales line table work fine while masure with sales line archive table din't work fine it's sum all the value.

so what i want that i take only one common dimension that will work fine on Measures of both table.
I think it some thing to do with SQL Business Intelligence Devleopment studio.
Read this link...
http://msdn.microsoft.com/en-us/library/aa198070(SQL.80).aspx
Thanks