on 12-24-2012 8:23 AM
Hi
Can we create attribute views based on other attribute views?
Thanks and Regards
anu
Hi Anu,
If you meant, including attribute views within other attribute view, then this isnt possible. You will have to make use of analytic views or calculation views to do further joins for an attribute view.
You can create what are called "derived attribute view". If you are familiar with SAP BW, they are like your reference characterisitcs. They are based on an attribute view of your choice. Only the description of your derived attribute view can be changed, everything else remains the same as your base attribute view. This is particularly useful in scenarios for e.g. Customer attribute appearing as Sold-To and Bill-To within a sales transaction. You may refer to this thread as well - http://scn.sap.com/thread/3235098
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I have used SLT to fetch tables from SAP Retail e.g., MARA table. Client doesnt want to change anything on SLT settings and want to fetch all fields. Since we are using only 20 fields from the table, I thought of creating attribute view on 20 fields and then use that attribute view with other tables rather than complete MARA tables.
Also, there are lot of tables in creating 1 big attribute views so wanted to check if there is option to create smaller views.
Thanks and Regards
anu
You should be using Text Join between tables within your attribute view for this purpose. You can use the default language property to control which language record is selected. Have a look at this demo on how text joins are done: http://scn.sap.com/docs/DOC-20088
Hi Anu,
You don't neccasarily have to filter the language column & hardcode it to a specific language as shown in that demo. When you use text joins & do a data preview, only those records will be picked up which corresponds to your logon language.
So within the HANA studio, if you right-click on your system connection on the 'Navigator Pane' and say properties - a popup appears and within there you select the database user logon, and the second tab (Additional Properties) within it. Under connection, "locale" tells you which langauge you are using to connect to the HANA database. You can change this to for e.g. German and then run a data preview on your attribute view with the text join and it will pick only the german texts/descriptions.
The same applies to UI as well . For e.g. when you connect Excel to HANA, you have the option to enter a language as part of the connection parameters.
Thanks,
Anooj
Hi Anu,
In BO, when you create the WebI report, there is an option to set the locale for the report. That can be used to get the user specific locale. I haven't successfully tried this yet, but worth looking into this option.
Also, so far I haven't been able to get the dynamic language text for Attribute views in Analytic / Calculation view. You can try that one also.
Regards,
Ravi
Hi Anu,
You can create attribute views based on other Attribute views as Reference. Is that what you are looking for.
What is the exact need as the referenced attribute views are not modifiable except for description.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.