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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 18, 2015 9:03 AM
Points: 57, Visits: 289
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 11:11 AM
Points: 743, Visits: 1,351
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 18, 2015 9:03 AM
Points: 57, Visits: 289
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