Display single value with dimension filter selection

[Former Member]

Hello,

I use Design Studio 1.3.

I want to display the correct single value after I choose a "Calyear" form dimension filter.

At the moment I can use the sum of all "Calyears"only.

Thanks for our help....

[Former Member]

This message was moderated.

[TammyPowlas]

Could you use the KPI tile (from the sample SDK) and see if that works?

[Former Member]

Hello Tammy,

I know, how a tile works. I use the KPI Template from Design Studio 1.3. I fill the tile value with the statement:

TILE_3_UM.setText(DS_4.getData("00O2TF25Z6L0MT28FMWJOHXQJ", {}).formattedValue + " EUR");

But now, I want to combinate with dimension filter. I want see the value form calender year "2012" (f.e.) only. (see the sceenshot).

At the moment I see the value from all years. But the correct value is 58.526.376. I want to see this value.

I have you got an idea?

Thanks

[TammyPowlas]

What is strange is the scenario works for me:

I filter on dimension project, and the binding in the KPI tile reflects that

How did you bind the KPI tile?  I bound it on the totals

[Former Member]

Question for you Mrs. Powlas:

I am have trouble getting pivot tables to refresh with the new data from SAP Business Objects Excel Plug In.  How you heard of others having problems? I can see the data in my BOBJ output but the data will not pull in my pivot table even though the data is all selected  for pivot table source (as a "cross tab.")

Thanks,

Caroline Knight

[TammyPowlas]

Caroline - this is in the wrong space - which product are you using?  Is it analysis office or another product?  Can you check the SCN site index at and post in the proper space

[Former Member]

I have create this Datasource:

In Script Editor I fill the value field with this Code:

DETAILS_VALUE_AE.setText(DS_3_AE_DETAIL.getData("00O2TF25Z6L0MSI7DYKIXACY3", {}).formattedValue + " EUR");

00O2TF25Z6L0MSI7DYKIXACY3 = Keyfigure "Aufragseingang"

Without filter the value is correct.

But when I filter (with dimension filter) the value doesn't works correct.

I think my code in script editor is not correct. Or must I use variables?

[TammyPowlas]

I didn't use code; I simply went in and "bound" the data to the total and the filtered value works.  Can you try it without the script and do the binding?

I didn't use variables either.