BW Workspace in Analysis Office
I am evaluating the workspace function for Analysis Office. AO Client is on version 18.104.22.16863.
I have already a BW Workspace defined and tested successfully the upload of a Local Provider and combination of a Local Provider with the Central Provider by creating a local CompositeProvider via the Workspace Designer (NW Business Client). Everything works fine so far.
In my scenario I want to define texts (descriptions) for a certain InfoObject (Pay Method), that has only KeyValues. The local Provider looks like this:
In AO Excel client the upload of that local provider works, if I select the for both columns the type "texts". But if I want to select the Type Dimension (InfoObject) I get an error, which states that the local provider XYZ could not be created, without further explanation. I also traced the error via BW-Trace in rstt, but the error was described the same short way like in AO Client. I suggest that selecting Type Dimension is just an indicator to define the column with the data type of the InfoObject (like a template). It isn´t clear to me why this error occurs.
In the next step I want to create a CompositeProvider, via AO client by adding the respective query on top of the central provider of the workspace to my workbook. After selecting the cell of the the query result the "Add" Button becomes active an I want to add the data created beforehand with the local provider. Now I don´t get the local provider for selection. Only the CompositeProvider I created via the NW Workspace Designer. The CompositeProvider has the same dimensions and key figures like the Query (based in central Provider) in the workbook.
If I add the CompProv I get an error which states "Der Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein." I use the german Client... Its something like: the index is out of range of the cross table.
Can somebody help me on this?
Thanks for the help!