Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube Replication (Duplication) using same data source & Enabling Detail Level Member in the Duplicate OLAP Expand / Collapse
Author
Message
Posted Thursday, April 24, 2014 9:54 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 23, 2014 9:48 AM
Points: 49, Visits: 252
Hi Guys,
I have 2 reporting systems, one which is our OLAP based source systems and one where we collaborate with other departments reporting data using BO

Now let’s take one dimension in my cube say Department, the OLAP cube was built to display department names only, but now my requirement for the new reporting collaboration has changed and I need to display properties along with names without disturbing the original reporting structure (Don’t want properties to show up in my source system)

So correct me if I'm wrong:

Can this be done?

1. Original Cube (Names) and Replicated Cube (Names and Enable Property details) pointing to the same relational data source (Data should be the same across both cubes). If yes how can I replicate or do a deduplication (Steps or Guide please)

Thanks,
VR
Post #1564947
Posted Friday, April 25, 2014 4:34 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 10:55 AM
Points: 640, Visits: 1,216
Have you considered having one cube and just using role based security on dimensions?

http://msdn.microsoft.com/en-us/library/bb500251.aspx






I'm on LinkedIn
Post #1565013
Posted Friday, April 25, 2014 8:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 23, 2014 9:48 AM
Points: 49, Visits: 252
It did cross my mind.I'll give this a try.But I would still like to explore the option highlighted.

Any more ideas .
Post #1565119
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse