So, this is a follow up question to this one i made before.
Basically, i wanted to go from
to
which i got.
My final problem is that i dont seem to be able to create a name for these fields for the datasets in ssas.
I tried:
FIELD NAME=CLOSED, FIELD SOURCE=
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Financial Data Month Validation].[Month Validation Status].[Month Validation Status].ALLMEMBERS" />
I tried ALLMEMBERS, CLOSED, OPEN and some other variations. I m new to this but i have been able to manually create fields before. I think its the two header columns crating my problem here. Any help?