I am in BPC 7.5 NW
I need to add a new dimension to an existing application with transaction data.
I have done it in the dev system and what I could see is for all the transaction records in the cube, the first member in the dimension member sheet got populated.
What I meant is, all the data records has the same dimension member. Is this the way it is supposed to work. If I need to populate data, how will I do it, Will I need to clear the data and reload again. How is it handled usually?
Also when there is a dimension property with more than 60 char length, how does the system handles it. I know that it will be extend the star schema again, but how does it work. Can I see the details of this? where can I get the table name if it is getting populated?