query used as source for load into cube

[dieterzenger]

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

[former_member194898 · Accepted solution]

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

[ccc_ccc]

Hi Dieter,

Try to map (0FISCPER3) . FISCPERIOD and FISCYEAR also, and check the data.

Regards.

Nanda