Solved
"Reusable cube" for dimensions
in a typical corporate data warehouse scenario, we'd have a wide range of facts covering different areas of the business. They in turn would likely be set up as different Elasticubes/models that hav...
Certainly! To implement shared dimensions using the EC2EC connector in Sisense:
- Create a Central Dimension Cube: First, build an ElastiCube (let's call it 'CentralDimensionCube') that houses all your shared dimensions such as Customer, Employee, Location, etc.
- Use EC2EC Connector in Other Cubes: In your specific fact-focused cubes (for example, 'SalesCube'), use the EC2EC connector. This connector allows you to reference the shared dimensions from 'CentralDimensionCube'.
- Link Dimensions to Fact Tables: Within these specific cubes (like 'SalesCube'), link the dimensions pulled from 'CentralDimensionCube' to your local fact tables. This creates a connection where your fact data in 'SalesCube' can utilize the dimensions defined in 'CentralDimensionCube'.
- Schedule Builds Appropriately: Ensure that 'CentralDimensionCube' is built or refreshed before your other cubes. This ensures that the most updated dimension data is used across your cubes.
By following these steps, you’ll efficiently reuse dimensions across multiple cubes in Sisense, maintaining consistency and reducing redundancy.
We'd like to hear how you go!
Attachment: Screenshot of the EC2EC connector on the "Choose Connection" page.
Derek NRAPID BI - Sisense Professional Services | Implementations | Custom Add-ons
