SAP Articles - Page 40 of 104

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:

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.

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

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.

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

Note that you can create Graphical Calculation Views using SMART Data access tables and you can also push aggregations to remote database.

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.

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

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.

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