BA Virtual Cube- Shared Dimension

ashbhardwaj
ashbhardwaj Member Posts: 89
edited 2009-04-30 in NAV/Navision Classic Client
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

Comments

  • vyanku
    vyanku Member Posts: 791
    if you have virtual cube then open that virtual cube in BA for analysis.
  • ashbhardwaj
    ashbhardwaj Member Posts: 89
    Hi
    Thanks , but where to define the share dimension in BA
  • vyanku
    vyanku Member Posts: 791
    What do you mean by shared dimension?
  • ashbhardwaj
    ashbhardwaj Member Posts: 89
    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

Categories