Found 1044 Articles for SAP

Using different Projection options in Calculation view in SAP HANA

SAP Expert
Updated on 12-Mar-2020 08:13:11

438 Views

When you set data category as CUBE, the default node is aggregation. When you set data category as Dimension, default node is Projection.You can change the Default node by selecting Star Join checkbox.When you finish selection for data category, you get a default node under Scenario pane. Check the below snapshot:

Advantages of using Calculation View without Star Join

SAP Developer
Updated on 18-Jun-2020 09:45:10

368 Views

When you use Calculation view with Star Join, you have the following benefits:It simplifies the design process.You need not create Analytical views and Attribute Views and directly Fact tables can be used as Projections.3NF is possible with Star Join.

Using SAP BusinessObjects dynamic recipient

Anil SAP Gupta
Updated on 06-Mar-2020 05:28:32

474 Views

In SAP BusinessObjects, you can deliver the reports as per business requirement. It is also possible to use dynamic recipient’s option to deliver reports to users based on their requirement or split reports based on different values of a characteristic.Let us understand this with an example, let us say you have 4 specific regions in the report and you want the report to be delivered to individual Regional Manager for their respective region. You can use dynamic recipient option to make it possible.To implement this, you need to create a dynamic recipient report by developing a webi report which contains ... Read More

Consuming Attribute/Analytic view in a Calculation view in SAP HANA

John SAP
Updated on 12-Mar-2020 08:14:26

197 Views

You can use Calculation View without Star Join to consume Attribute and Analytic view in SAP HANA. To use these views, you can add Projection node and add the views to the projections.In this, you can see how to create a Calculation view without Star Join. To add Project node, you can simply drag it from the right side.

Using fact and dimension tables in SAP HANA Modeling

SAP ABAP Expert
Updated on 30-Jul-2019 22:30:22

940 Views

The fact table contains measure values and primary key for Dimension tables. Dim tables contain master data. Fact and dimension table are joined in HANA Modeling to achieve some business logic.Example of Measures − Number of unit sold, Total Price, Average Delay time, etc.Dimension Table contains master data and is joined with one or more fact tables to make some business logic. Dimension tables are used to create schemas with fact tables and can be normalized.Example of Dimension Table − Customer, Product, etc.Suppose a company sells products to customers. Every sale is a fact that happens within the company and ... Read More

Consuming Graphical calculation view via SDA

SAP Expert
Updated on 06-Mar-2020 05:24:38

201 Views

Note that you can create Graphical Calculation Views using SMART Data access tables and you can also push aggregations to remote database.For more details, you can refer this blog to Smart Data Access: The power of Smart Data Access (SDA) with SAP HANA SP08http://www.saphanacentral.com/2015/03/the-power-of-smart-data-access-sda-with.html

Using parallel processing in SAP HANA

John SAP
Updated on 30-Jul-2019 22:30:22

612 Views

With the use of column based storage in HANA, data is available vertically and hence operations on different columns can be easily performed. When there is a requirement to process to process more than one column, it is processed by the different processor.

Count distinct entries in SAP BusinessObjects

John SAP
Updated on 06-Mar-2020 05:22:37

497 Views

Your requirement is not clear but I think you should use AND operator and count on this in the third column. Your formula should be like this=([First_Seen] = 1) and ([Authorized] = 1)Consuming Graphical calculation view via SDA

Getting error while running SAP oData service “HTTP Open failed: PLUGIN_NOT_ACTIVE”

SAP ABAP Expert
Updated on 06-Mar-2020 05:21:52

395 Views

To fix this, you need to run T-Code: SMICM and this will open ICM Monitor Service Display. You need to maintain port number 80000 for HTTP in SMICM.

Hiding null values in a column in SAP Crystal Reports

Anil SAP Gupta
Updated on 06-Mar-2020 05:21:13

323 Views

I am not sure where this formula is written. You have to write this formula in suppress part of Section Expert.To open section expert, right-click Report Header → Section Expert  click x→2 or suppressAlso, note that you can write the formula in any section where data is present in your report. Try below formulaToNumber({Choice_.Choice1}) > 0 //You have to ensure choice1 should always a numeric value else report throws exception

Advertisements