How do we get "total" rows or "breaks"?

[Former Member]

Hey guys,

Is there a way to obtain row "totals" (known as breaks in Webi) via the RESTful services?

I'm trying to obtain them via the dataset call, but they aren't appearing:

https://company.ca:6543/biprws/raylight/v1/documents/2138228/reports/1/elements/14/dataset

EX:

Hiding the actual values, here is what I get when I call /dataset:
Notice how it leaves out the "total" rows as shown above in the Webi document

...

<row><value>01-BUSINESS LEVEL and REVENUE</value>

  <value>Revenue Tons per Load</value>

  <value>111</value>

</row>

<row><value>01-BUSINESS LEVEL and REVENUE</value>

  <value>Trailing GTMs</value>

  <value>111</value>

</row>

<row><value>03-TRIP PLAN</value>

  <value>Assessed Carload Trip Plans</value>

  <value>111</value>

</row>

<row><value>03-TRIP PLAN</value>

  <value>Assessed Intermodal Trip Plans</value>

  <value>111</value>

</row>

<row><value>03-TRIP PLAN</value>

  <value>Carload Trip Plan Performance (Pct)</value>

  <value>1111</value>

</row>

<row><value>03-TRIP PLAN</value>

  <value>Failed Intermodal Trip Plans</value>

  <value>111</value>

</row>

<row><value>03-TRIP PLAN</value>

  <value>Intermodal Trip Plan Performance (Pct)</value>

  <value>89.1</value>

</row>

<row><value>03-TRIP PLAN</value>

  <value>Trip Plan Fails (Car)</value>

  <value>1111</value>

</row>

<row><value>04-YARD</value>

  <value>Avg Industry Process Dwell</value>

  <value>1111</value>

</row>

<row><value>04-YARD</value>

  <value>Avg Through Dwell</value>

  <value>111</value>

</row>

...

Note: this is on version BI 4.1 SP3.

Thanks!

Scott

[former_member197386 · Accepted solution]

hello Scott!

You're right, breaks values don't appear into dataset since this data is about underlying data used to prepare the rendering.

Did you have a look to the Report Output?
(You have to export the report element with text/xml MIME type to get it)

Probably we should since about a better/easier way to get breaks values throught RESTful API.

Best regards,

Anthony

[Former Member · Accepted solution]

Hey Anthony,

Yea I don't think parsing through the MIME output would be easy to handle.

Like you said they should definitely find a way to allow totals to be pulled with the data.

Thanks!

Scott