Hi,
I have created a transparent partition between Planning application and essbase BSO cube but i am facing the cell count mismatch issues with the below definition. Company Code and Functional Area are attribute dimensions and they are assigned to Cost Center dim.
Source Planning app: Account, Period, Years, Currency, Scenario (=Current), Version (=Working), Cost Center, "Company Code" (Attribute dim), "Functional Area" (Attribute dim)
Target Essbase cube: Account, Period, Years, Currency, Scenario (=WorkingForecast), Project, Cost Center, "Company Code" (Attribute dim), "Functional Area" (Attribute dim)
Partition Definition:
Source Area:
"Account1","Period1","Years1","Currency1","Cost Center1",@Attribute("Company Code"),@Attribute("Functional Area"),"Current","Working"
Target Area:
"Account1","Period1","Years1","Currency1","Cost Center1",@Attribute("Company Code"),@Attribute("Functional Area"),"WorkingForecast","Project".
Source Mapping; Target Mapping
Working (void)
"Current" "WorkingForecast"
(void) "Project"
Warnings:--------------
[Target] - Partition definition is not valid: [Dimension count mismatch in area 1]
[Target] - Partition definition is not valid: [Cell Count mismatch: [2230] area for slice [1] members per dimension [1 1 1 1 1 1 2230]
[Source] - Partition definition is not valid: [Cell Count mismatch : [1] area for slice [1] members per dimension [1 1 1 1 1 1 1]
I have removed attribute dimensions from the partition definition but of no use. The below warning has shown up.
[Target] - Partition definition is not valid: [Dimension count mismatch in area 1]
Any pointers is really appreciated. Thanks for your help in advance.
Regards,
Praveen