Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

query used as source for load into cube

Hi all,

I have defined a Query and will use it as source for transformation and load into info cube.

Unfortunately the extraction is not filling the Period at all (0FISCPER3). The Fiscal year variant and the fiscal year and the remaining characteristics

and Key figures are forwarded properly. when executing the query with RSRD the Period is filled without any issue.

any idea, what I am doing wrong ?

thank you

dieter

replied

Hi,

If 0fiscper is loaded properly you may use that characteristic to fill 0fiscper3.

load it with RIGHT( 3, FISCPER ) formula.

Hope that helps,

Leszek

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question