How to use BPC MS data in Xcelsius.pdf
Hi,
I'm working through the above "How To...." guide and have not been able to extract the correct results when testing the web service using the following url (step 18, page 13)
http://Localhost/Osoft/App/XcelsiusService/QueryResults.asmx/Results?Query=MyRange:Time:2006.Jan,2006.Feb,2006.Mar,2006.Apr,2006.May,2006.Jun|Entity:SalesUSNeast,SalesUSNcentral,SalesUSNwest,SalesUSSeast,SalesUSScentral,SalesUSSwest&AppSet=Apshell&App=FINANCE&showRowHeaders=true&showColumnHeaders=true
I get a xml result but it returns zero against all Entity and Time members - I have tested that data exists at these intersections via BPC for Excel.
What am I doing wrong?
Many thanks
<?xml version="1.0" encoding="utf-8" ?>
- <data>
- <variable name="MyRange">
- <row>
<column />
<column>2006.Jan</column>
<column>2006.Feb</column>
<column>2006.Mar</column>
<column>2006.Apr</column>
<column>2006.May</column>
<column>2006.Jun</column>
</row>
- <row>
<column>SalesUSNeast</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
</row>
- <row>
<column>SalesUSNcentral</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
</row>
- <row>
<column>SalesUSNwest</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
</row>
- <row>
<column>SalesUSSeast</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
</row>
- <row>
<column>SalesUSScentral</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
</row>
- <row>
<column>SalesUSSwest</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
<column>0</column>
</row>
</variable>
</data>