Can I use a selection when extracting a cube?
Hiya,
I'm pretty new to playing around with Board, so forgive me if this is a simple question.
I've got a cube in one database with the dimensions of: Period, Branch, Category, GL and Scenario.
I want to extract the cube, but only where there are values against Scenario 3, to copy into a cube in another database (dimensions of Period, Branch, Category and GL).
I set up a simple procedure where I selected Scenario 3 and then the second step extracts the cube.
When I've imported it into the second database, it appears that data from all the scenarios are present.
Can anyone tell me where I'm going wrong? Do I have to have an entity for Scenario set up in my second database and the cube structured the same?
Emma
Answers
-
Dear Emma Howard,
thanks for your request.
For general the procedure you build up should work as expected from your side.
Never the less you can also do the following.
Build up temporarily cube on your source database. This one should have the same dimensions instead the version.
In your procedure you select the version to extract and first perform a dataflow to your temporarily cube.
In second step you extract your temp cube and got the wished behavior.
regards
Alexander Kappes
1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 161 Academy
- 328 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 194 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 5 Community Captains
- 1 About Community Captains
- 3 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 338 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP