on 05-03-2016 12:07 PM
Hi Experts,
I am working on a use case where i need to create dynamic views on the run.
Scenario : User selects data for age>65 and applies filter on the same data whose visited the doctor >5 times this month.
In this case we have two views age>65 and then >5 times visit.
similarly i have more than 1000+ filtering scenarios.
First question:
1. What is the best approach to deal with this situation?
2. I found that there is a calculation view approach that can be used since CACHE mechanism is also required in this :
EXEC 'CREATE CALCULATION SCENARIO "SchemaName"."View_Name" USING ''<?xml version="1.0" encoding="utf-8" ?>
<cubeSchema version="3" operation="createCalculationScenario" defaultSchema="SAP_HPH">
<calculationScenario name="Hello_World">
<dataSources>
<sqlViewDataSource name="INPUT" view="ViewName">
<attributes>
<attribute name="Filename" datatype="string" sqlType="NVARCHAR" />
<attribute name="DOCUMENTNAME" datatype="string" sqlType="NVARCHAR" />
</attributes>
....
Where can i find documentation to create such kind of views? <cubeSchema > <dataSources> <sqlViewDataSource > Where can i find the definition for all these XML components?
Thanks,
Abhishek.
The XML definition for calculation views are not open for development outside SAP.
As a SAP developer you have access to internal JAM communities, documentation and core SAP HANA development teams.
I recommend to reach out internally instead of posting here in a public forum,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure about the scenario, but if you are after BRF+ kind of scenario, please check the link which Krishna has given for HRF.
I would suggest why cant you create a decision table with all the condition and
You can create Calculation view and inside that you can consume decision table. that way you can update the decision table also and calc view will run based on the rule present in decision table .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.