workbook calculated field from another query is not showing in crosstab

[Former Member]

Hi all,

Here i have a scenario like below..

I have a saved workbook in Analysis for Microsoft Office(Version - 1.4.10) it contains 3 different queries.One is main query and others are supporting queries for some calculations.That means my main query result is showing calculated KFs from main query as well  as calculated KFs from other queries also.Up to this it is fine and good.When i open this report in Design Studio with the feature "Create Web Application"  it is showing calculated KFs from main query only in Crosstab and calculated KFs from other queries which are on main query is not showing in cross tab in Design Studio.Is there any way to show all KFs in cross tab or any other way to join these different cross tabs in Design studio?

AO version(1.4.10)

DS Version(1.4.2)

rgds,

aby

[former_member225306]

Hi,

Please check the below link:

http://scn.sap.com/thread/3739308

Thanks and Regards,
Venkat