cancel
Showing results for 
Search instead for 
Did you mean: 

How to use BPC MS data in Xcelsius.pdf

Former Member
0 Kudos

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,200...

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>

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member204026
Active Participant
0 Kudos

Hi,

Please try adding more filter conditions to your query and try.

For ex:

http://<hostname>:port/OSoft/App/XcelsiusService/QueryResults.asmx/Results?AppSet=ApShell&App=FINANC...

Regards,

Badrish

Former Member
0 Kudos

....for some reason the url I included has been truncated

Reposted

http://<hostname:port>/Osoft/App/XcelsiusService/QueryResults.asmx/Results?Query=MyRange:Time:2006.J...

Entity:SalesUSNeast,SalesUSNcentral,SalesUSNwest,SalesUSSeast,SalesUSScentral,SalesUSSwest&

AppSet=Apshell&App=FINANCE&showRowHeaders=true&showColumnHeaders=true

former_member204026
Active Participant
0 Kudos

Hi,

We faced this issue in the past, the possible solution for this issue are.

A. Check your security permissions

B. Server name should be hard coded, you should not use http://localhost; since this will not work from out side

C. Check the dimension, if they are mentioned correctly. (if evdre is working fine then it should be fine

Hope this helps.

Badrish

Former Member
0 Kudos

Thanks for the reply Badrish,

Unfortunately I have tried various things including the three you mention but without success.

Will keep trying

former_member146451
Participant
0 Kudos

Hi,

I have the same problem. Does anyone know a solution?

Regards,

EZ