Analysis for Office 1.4.7 Can't do calculation based on HANA data

[Former Member]

Hi,

We are currently using Analysis for office 1.4.7 based on HANA data. When we try to use calculation, we got following error.

---------------------------------------------------------------------------

Nested exception. See inner exception below for more details:

Unable to execute SQL statement (CREATE_COLUMN_VIEW) \: CREATE OLAP SCENARIO '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<cubeSchema operation="createCalculationScenario" version="3">

    <calculationScenario name="POC-zmlf-fico-histcopatma-pkg/CALV_SHCOPATMA_MUL_1408373161431" schema="_SYS_BIC">

        <scenarioHints createInMemoryOnly="false"/>

        <dataSources>

            <analyticDataSource view="POC-zmlf-fico-histcopatma-pkg/CALV_SHCOPATMA_MUL" schema="_SYS_BIC" name="columnViewSource">

                <attributes>

                    <allAttribute/>

                </attributes>

            </analyticDataSource>

        </dataSources>

        <calculationViews>

            <aggregation defaultViewFlag="true" name="defaultAggregation">

                <inputs>

                    <input name="columnViewSource"/>

                </inputs>

                <viewAttributes>

                    <allViewAttribute/>

                </viewAttributes>

                <keyfigures>

                    <allKeyfigure/>

                     <calculatedKeyfigure datatype="double" aggregationType="sum" name="[Measures]_Formula1">

    <formula>("G_QVVNTW" - "ZKGPSTD")</formula>

</calculatedKeyfigure>

                </keyfigures>

            </aggregation>

        </calculationViews>

    </calculationScenario>

</cubeSchema>' (ERROR [S1000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;258 insufficient privilege: Not authorized)

---------------------------------------------------------------------------------------------------------------------------------------

Currently the account we use has select access to "_SYS_BIC". What else do we need in term of priviledge?

Thanks.

Terry

[Former Member]

Once we added "Create Scenario" system privilege to the HANA account we use, above error was gone but we only get "No applicable data found".

Before we apply calculation, the data was there and disappears once we added calculation.

[TammyPowlas]

Hi Terry - it sounds like this is more of a HANA security question, which is better suited for the HANA space.  Do you want me to move this to that space?

[Former Member]

Hi Tammy,

We can do calculations now with Create Scenario" system privilege.

The issue I am facing was what objects we can do calculation and what objects I can't or should not.

Example:

     I can do calculation between kilos and Net Weight(Kilos) since both are quantity. Once I bring in Gross Profit at Standard which is dollar value into my calculation, I got "No applicable data found".