Hi everyone.
I have data source (extract) that contain metadata orginized in folders, hierarchies and a lot of calculated fields. It works well at server. But if I need to apply some changes I downoload it from server, apply some changes and it askes me to refresh it. But after refresh:
- all attributes that were located inside of folders move out of them.
- All hierarchies and calculated fields are invalid, because attributes use names like [Customer_Name], but calculated fields were changed for some reason and tries to get column [customer_name].
All these happens right after refresh, while refresh itself finishes well
2 answers
This could be a bug, but I wouldn't be surprised if this is by design.
Why don't you keep the original workbook that created the extract, and use it for making changes and publishing to server? This method shouldn't have any of these issues.
