The Root Element is Missing

[Former Member]

Hi all,

I'm trying to Maintain " Dimension Member Sheet". I'm getting "The Root Element is Missing" error. I feel there was an issue with Member Sheet.

Because of this issue, I could'n' even open member sheets. How can i access member sheet? Can any of you help me to fix this issue.

Thanks,

Ben.

[Former Member · Accepted solution]

Hi,

Please try deleting the xml files corresponding to the dimensions from the backend and try opening the dimension member sheet.

For deleting the XML file follow the workaround in my reply of the below thread,

Hope this helps,

Regards,

G.Vijaya Kumar

[Former Member · Accepted solution]

Thanks Vijay!!!

I will try that option and keep you updated.

[Former Member · Accepted solution]

Vijay,

I tried after delete and processing. still, i'm getting same errorr. Let me know if you can think of any other way we can fix this.

thanks,

Ben.

[Former Member · Accepted solution]

try to implement wht i had suggested

[radharamansingh_rajkumar · Accepted solution]

Hi,

Can you tell what is the status of your Appset.

Open admin console and click on Appset Name and in action pane you will get status of your Appset.

If it "Not Available" then try login to Business Warehouse use transaction UJFS, select your application set, select the "adminapp" folder. Select the excel file of your dimension where you have the problem. Delete it.

Go to BPC Admin, re-open the dimension membersheet. This should work now. Reprocess the dimension (this replaces the excel file of your dimension in UJFS).

Regards

Raman

[Former Member]

after doing all these, still my issue wasn't fixed. I found after spending some time on forums... could be because of earlier SP level. I delete my appset and recreated another one. Appreciated all your help!!!

[Former Member]

In My documents there will be BPC folder.

Browse in that till you reach your appset and you will find our dimension files in .xml extension.

rename the dimension (problem one). And then from Admin client try to open again.