Tweet
Hey. I have a multi member file. From its specific member, you need to select data and join it with the data of another table.
To solve this problem, I wanted to do the following:
1. Create an alias for the member I need.
2. Create a view using the created alias and another table.
However, it failed to create the view. The error is this:
I found a solution proposal here: https://www.ibm.com/mysupport/s/ques...language=en_US. The author says that you should not use VIEW ---> ALIAS ---> TABLE, but ALIAS ---> VIEW ---> TABLE. But the view has no members, so I cannot create an alias for the view.
Tell me, does the problem have a solution?
To solve this problem, I wanted to do the following:
1. Create an alias for the member I need.
2. Create a view using the created alias and another table.
However, it failed to create the view. The error is this:
Message. ... ... ... : Alias T1M1 for table T1 in CSNTST not valid for statement.
Cause. ... ... ... ... : The SQL statement cannot be performed on alias T1M1
because the alias refers to a member of table T1 in schema CSNTST.
Recovery. ... ... : Specify a valid table or an alias that does not refer to a
member. Try the request again.
Cause. ... ... ... ... : The SQL statement cannot be performed on alias T1M1
because the alias refers to a member of table T1 in schema CSNTST.
Recovery. ... ... : Specify a valid table or an alias that does not refer to a
member. Try the request again.
Tell me, does the problem have a solution?