i have following:
1. A flat file contains data for my "MEASURE DIM" and two columns to map date and property with existing Period and Property code dimensions. i understand and can create cube from above three dimensions Not a problem.
2. Now i have same flat file and want to add following additional existing dimensions also when creating a cube. I do not have any column or data available in my flat files to Map these dimension. Please help me to add and map these dimensions to step 1. Thanks so much for your help.
Account dim (General Ledger Account)
Prop Organization Dim
Pinned topic need help creating new cube from flat file and existing dim.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-22T09:52:43Z at 2012-06-22T09:52:43Z by SystemAdmin
Re: need help creating new cube from flat file and existing dim.2012-06-18T11:23:08ZThis is the accepted answer. This is the accepted answer.Can you please explain your question with some screenshots if possible. it is a bit confusing to understand your requirement.
Re: need help creating new cube from flat file and existing dim.2012-06-22T09:52:43ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Go through each sublinks to understand its functioning as you need to map your flatfile with the cube or you might need to use a lookup cube to insert values in the cube.
I might be wrong in understanding your requirement, but whatever i understood i provided solution for that. Just trying to help you out!!