How to extract entities in code with cube extraction
Hello.
I'm currently failing to reload the data because the input data in the cube is extracted with the description rather than the code. I think the problem could be solved if the data could be output in code.
I would like some advice as I am currently facing this issue and don't know how to resolve it.
I'm sorry that the screenshot is in Japanese and it's hard to understand. Please let me know if you have any additional information that would be helpful.
① In the attached data view, I designed the end user to display a description of the entity "メンバー(Member in Japanese)" and have them select and input data. The data type of the cube I am using for the data view is text.
②Then I extracted the cube to a text file.
③ I would like to read the text file with a data reader, read the 、メンバー entity (cell C3), and based on the result, write flag (1) in another cube with the メンバー entity on the axis (cell D6).
The problem is that in step ①, the user is asked to enter a description of メンバー entity, so the text file in ② outputs the description instead of the code of メンバー entity. As a result, an error occurs when loading the メンバー entity in step③ because there is no code.
I would like some knowledgeable people to help me.
Regards,
MSugiyama
Dataview
Layout of the Dataview
Datareader
Answers
-
Hello MSugiyama,
The main issue is that you don't have the the entity code in the text cube. I assume that the users are selecting the description from an entity in a pick list or dropdown. If that is the case then all you need to do is change the Data Entry configuration setting for the Suggested Values to "Code and Description". By doing that, the code and description will both be available in the dropdown and the users will populate the text cube with both the Code and Description. You will then be able to utilize the code in your data reader.
1 -
Hello Msugiyama,
There is also a reference manual that could guide you through the extract action.
0
Categories
- All Categories
- 1.9K Forums
- 1.8K Platform
- 150 Academy
- 313 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 47 How-To Guides
- 19 Board Advocacy Program
- 183 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 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
- 334 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP