How to self-join within an Analytic View?

[Former Member]

I have a need to perform a self-join, and would like to do it within my Analytic View but the system won't let me. Is there a way around it?

My scenario much more complex than this example, but the concept is the same

ex: Fact.Date -> Calendar1.Date, Calendar1.PrevWeekNum -> Calendar2.WeekNum.

This logic is used to split my sales data across weeks within a Calculation View. Currently Calendar2 is joined within the CV but I'd rather push it down inside the AN. I know I can do it with an AT at the logical join level, but it's inelegant/kludgy and should be part of the foundation.

ERROR:

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:exception  1: no.8104012  (mdx/metadata/deployment/join/JoinManager.cpp:471)n Self-join detected for table MYSCHEMA:TABLE123A

Any thoughts are appreciated.

--thanks,

[luisdarui · Accepted solution]

You won't be able to do this join within an Analytical View. A self-join would be supported in the context of a logical join only, and as per the documentation, you can perform a self-join within Attribute Views.