Webi：如何让用户在表中缩放数字（数千，数百万，...）（不在图表中）

发布于 2025-02-02 14:02:22 字数 1636 浏览 1 评论 0原文

（ SAP BusinessObjects BI平台4.3支持包1补丁11 版本：14.3.1.4142.11 ）

大家好，

假设我

在左侧有这张桌子，一个代表
右边产品的标识符，从销售此产品

现在，我在文档上的某个地方也有一个信息告诉用户显示这些金额的货币和“缩放”：例如，以$”或“ 1'000 $”等的“金额”等等。

我想要的是让用户在需要时选择哪个缩放这些金额应该显示，我不希望他每次要重新销售时都可以刷新数据。因此，这意味着，如果值为1'234'567'890 $，则用户应能够扩展值并显示Eg 1'234,57 mio. $。实际上，价值并没有真正改变。只有显示的方式才会改变。

我搜索了很多东西，并尝试了很多事情。到目前为止，我设法做的事情已经接近，但还不够好。

工作解决方案（但不够好）

缩放值1至10亿，

我可以在我们的信息设计工具中创建一个具有这些值的派生表：1，1'000，1'000'000，1' 000'000'000，作为数字。然后，我将这些值导入我们的Webi文档，并尝试使用它创建输入控件。它正在工作，但是由于这些是“数字”，所以我无法按预期选择输入控制“列表”，因为那时我了解到，此输入控件仅与“ dimensions”一起使用（

用滑块缩放。

缩放值1至9

我所拥有的另一个想法是使用10个幂：例如10^1，10^3，10^6和10^9。这也可以正常工作，我没有价值问题，这没有任何意义，但我认为这还不清楚。我也不认为任何人都不会使用10^4或10^7来扩展数据，但这并不那么问题。问题是...我不知道人们是否会使用此报告的人是否熟悉10。

不使用解决方案

我尝试的第一件事是使用自定义格式选项（＃，##等），但我无法使其起作用。例如，我还尝试使用k或m，这是Excel关键字，并且由于Webi与公式中的Excel具有相似之处，因此我认为它可以起作用，但行之有效。

我尝试的另一件事是创建一个带有值1、1'000等的派生表，为“尺寸”，并直接在Webi中的公式中转换它们，但是这些单元格是空白的，我不知道为什么。该公式很简单

=[Amount]/[Scaling factor]

，我试图使用Todecimal或Tonumber功能，但没有成功。可以与以下事实联系在一起，表的结构非常复杂，可以显示几组以显示其总和（就像带有子类别和所有内容的资产负债表一样）。

无论如何...如果可能的话，有人知道该怎么做吗？我发现无法在数字上使用输入控制列表非常令人沮丧。我不明白，为什么如果特定值是数字而不是维度，为什么我不能在特定值之间进行选择。

当然，如果您有疑问和/或某些东西还不够清楚，我仍然在这里。

感谢您的时间！

PS：我没有发布图像的声誉，所以您只有链接，对不起

原文

(SAP BusinessObjects BI Platform 4.3 Support Pack 1 Patch 11
Version : 14.3.1.4142.11)

Hello everyone,

Let's say I have this table with

On the left, an identifier representing a product
On the right, the amount of money gained from selling this product

Example of products identifier and their corresponding amount of money gained from selling them.

Now, I also have an information somewhere on the document telling the user in which currency and "scaling" these amount are displayed: e.g. "amounts in $" or "amounts in 1'000$", etc.

What I want is to let the user choose whenever he wants in which scaling these amounts should be displayed and I don't want him to refresh the data each time he wants to rescale. So that means that if the value is 1'234'567'890$, the user should be able to scale the value and display e.g. 1'234,57 Mio.$. In fact, the value does not really change. It is only the way it is displayed that changes.

I searched a lot and tried a lot of things. What I managed to do so far is close, but not good enough yet.

Working solutions (but not good enough)

Scaling values 1 to 1 billion

I could create a derived table in our Information Design Tool with these values: 1, 1'000, 1'000'000, 1'000'000'000, as numbers. I then imported these values in our Webi-Document and try to create an input control with it. It's working, but since these are "numerics", I couldn't choose the input control "list" as expected, because, I learned then, that this input control is working only with "dimensions" (Input control types).
The problem is, that with a slide we can choose all values between the minimum and the maximum value (1 to 1'000'000 in the example below). It makes no sense to scale with a factor of 213'000 for example. So it's working, but it is not a "professional" solution.

Scaling with slider.

Scaling values 1 to 9

The other idea I had was to use powers of 10: e.g. 10^1, 10^3, 10^6 and 10^9.
This is also working and I don't have the issues of the value, which makes no sense, but it is less clear, I think. I also don't think that anyone will use 10^4 or 10^7 to scale the data, but it is less problematic.
The thing is... I don't know if the people, who will be using this report are familiar with the powers of 10.

Not working solutions

The first thing I tried was using the custom format options (#,##, etc.), but I could not make it work.
I also tried with the K or M for example, which are Excel keywords, and since Webi has similarities with Excel in the formulas, I thought, that it could work, but it did not.

Another thing I tried was to create a derived table with the values 1, 1'000, etc. as "dimensions" and convert them in the formula directly in webi, but the cells are then blank and I don't know why.
The formula is simply

=[Amount]/[Scaling factor]

And I tried to use the ToDecimal or ToNumber functions, but without success. It may be linked to the fact, that the structure of the table is very complexe with several groups to display their sums (something like a balance sheet with subcategories and everything).

Anyway... does somebody know how to do it, if it is possible? I found it quite frustrating to not be able to use the input control list on numerics. I don't understand, why I should not be able to choose between specific values if they are numbers and not dimension.

Of course, I'm still here if you have questions and/or if something is not clear enough.

Thanks for your time!

PS: I don't have the reputation to post images, so you only will have the links, sorry

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

岁月蹉跎了容颜 2025-02-09 14:02:23

实际上，我今天遇到了一个解决我问题的解决方案的人，所以我正在与您分享，以防其他人遇到同样的问题并且也在挣扎。

这个想法是要与我在第二次“不工作”尝试中尝试的事情相反。问题是将缩放因素作为数字。然后，我们创建一个变量并在维度中转换缩放系数。然后，我们使用此变量来创建输入控制列表。

我们正在使用信息设计工具（IDT）在我的工作中连接Webi和Teradata，因此此答案将使用这些工具。

在IDT中，

在您的数据基础中创建一个带有您想要的值的派生表。对我来说，是1、1'000、1'000'000和1'000'000'000。我使用了此SQL：

SELECT CAST('1' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL" UNION ALL
SELECT CAST('1000' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL" UNION ALL
SELECT CAST('1000000' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL" UNION ALL
SELECT CAST('1000000000' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL"

在您的业务层中拖放新创建的表并发布您的Universum。

在Webi中，

打开您的数据提供商，并使用相应的Universum进行新的查询。
使用公式：= formatnumber（[scaleMeasure];“ #############”），创建一个新的变量 scaping_dimension_dimension_for_input_control “）。它必须是一个维度。
<
选择列表类型，并防止用户选择多个值。您必须选择一个默认值。
输入控件的配置

缩放输入控件将看起来像这样缩放输入输入控制

直接在表中使用缩放度量，或使用变量将所需的数量除以此缩放因子：
= [量]/[缩放因子]

现在，当您更改缩放因子时，它将更改表中的值。

享受！

I actually met someone today, who found a solution to my problem, so I am sharing it with you in case others are having the same problem and are also struggling.

The idea is to do the contrary of what I tried in my second "not working" attempt. The thing is to have the scaling factors as numbers. Then we create a variable and convert the scaling factor in a Dimension. We then use this variable to create an input control list.

We are using Information Design Tool (IDT) to connect Webi and Teradata at my work, so this answer will be using these tools.

In IDT

Create a derived table in your data foundation with the values you want. For me it was 1, 1'000, 1'000'000 and 1'000'000'000. I used this SQL:

SELECT CAST('1' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL" UNION ALL
SELECT CAST('1000' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL" UNION ALL
SELECT CAST('1000000' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL" UNION ALL
SELECT CAST('1000000000' AS NUMBER) AS Skalierung  FROM (SELECT 1 AS "DUMMY") AS "DUAL"

Drag and drop the newly created table in your business layer and publish your Universum.

In Webi

Open your data provider and make a new query with the corresponding Universum.
Create a new variable Scaling_Dimension_for_Input_Control with the Formula: =FormatNumber([ScaleMeasure]; "##########"). It must be a Dimension.
Configuration of the Dimension variable
Create a new Input Control with this new Dimension. Choose the list type and prevent user from selecting multiple values. You must choose a Default value.
Configuration of the Input Control

The scaling input control will look like this Scaling input control