on 01-14-2014 5:00 PM
Hello
I have created a graphical calculation view,which is running sucessfully.
Example :-
table1, table2 -- > join_1 ( table1.id =table2.id) --> projection_1 -> Aggregation -- > Output.
At 'projection_1' , I have renamed few columns ( given user friendly name )
Example : - Table1.EmpNo renamed to EmployeeNumber.
Table2.DeptNo renamed to DepartmentNumber.
My question is :-
which system view ,can give me the entire list of the all attributes/measures of that calculation view?
Note :- I have check M_CE_CALCVIEW_DEPENDENCIES,M_CE_CALCSCENARIOS views , but didn't get the results which I am looking for.
Also checked CS_VIEW_COLUMNS view but that is for Attribute and Analytic view.
Regards
Sayan
Hi Sayan,
Use the following CE function to get the list of fields from calculation view.
CE_CALC_VIEW
Regards,
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vijay,
Thank you for your reply.
But CE_CALC_VIEW would not solve my purpose.
Let me put my questing in this way : -
I am looking for a table name which will return the Metadata(like field names and table names) of the given Calculation view ( like CS_VIEW_COLUMNS for Attribute and Analytic view) ?
Hi Sayan,
Please refer to the following help document link. Check on VIEW_COLUMNS and TABLE_COLUMNS.
Regards,
Vijay
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.