cancel
Showing results for 
Search instead for 
Did you mean: 

Option to select crosstab is not appearing in component tab in analysis

Former Member
0 Kudos

Hi All,

As shown in the below screenshot, I am not getting the toolbox where data source name and cross tab gets displayed because of which I am not able to use repeat members functionality. Repeat members option appears when we select cross tab which appears under the 'by data source' option tool box.

As the toolbox is not appearing below it I am not able to proceed further.

I tried re installing analysis but still facing the same issue. And it not with just 1 workbook. With all the workbooks I am getting the same issue. Version of the analysis is R1.4 -- v1.4.10 SCV3.

Thanks in advance for your help.

Regards,

Purva.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Steffen/ Basavaraj,

Thanks for your reply.

Will try this option and let you know if this solves the issue.

What is weird is that for the same version in another system I am not getting this issue.

Regards,

Purva.

Former Member
0 Kudos

Hi Purva,

Please unstall and install, then try may be it will solve your issue.

May be something wrong while installing, as you mentioned it is working fine another PC.

Thanks and Regards,

Basavaraj

Former Member
0 Kudos

Hi Basavaraj,

I tried this. Uninstall and re installing it. Still the same issue exists.

Regards,

Purva.

Former Member
0 Kudos

Hi Purva,

Please check the below option from ribbon menu.

Once you opened workbook please refresh and try.

And which version are you using?

Lastest version of Analysis office is 2.3SP1.

Hope this help you.

Thnaks and Regards,

Basavaraj

Former Member
0 Kudos

Hi Basavraj,

Thanks for your reply.

As shown in below screenshot I am unable to find the crosstab option you have shown.

Can you please let me know if there is any setting by which I can get that option.

Thanks in advance.

Regards,

Purva.

Former Member
0 Kudos

Hi Purva,

in AO 1.4 you don't have the Option "Crosstab" in the "Format" Area.

The screenshot Basavaray made is of AO 2.3

Best regards.

Steffen

Former Member
0 Kudos

Hi Purva,

That option will be available only after 2.x code line.

I think still you are in 1.x code line.

That will be end of maintainance(1.x) ,upgrade to 2.x.
Once you upgraded , you will be able to see that option.

Thanks and Regards,

Basavaraj

0 Kudos

Hi Purva,

First of all i am unable to see your image as per my understanding of issue.

Try this solution

Click in Display option in ribbon menu to see component tab option.

And your using very old version.

Kindly updated to AO 1.4 SP17 patch which is latest version in AO 1.4

I advice your to migrate to AO 2.3 as per your plan.

If still its not working click on Query design option in ribbon menu check how query is designed.

If this solution works for you  kindly mark it as correct option in solution.

Best Regards,

Shiva

Former Member
0 Kudos

Hi Shiva,

Thanks for your reply.

The current version which I am using is 1.4.10.3290.

When I click go to component tab, I cannot see the data source name and crosstab as shown in below screenshot.

I hope the screenshot is clear. If not please let me know.
I will try the option of installing the new version. But for the same version on another PC I am not getting this issue.

Regards,

Purva.

0 Kudos

Hi Purva,

Its basic functionality it should work.

Please updated to AO 1.4 SP17 patch. As I said in past updated to AO 2.3 to get more new features and quick support.

If issue is not resolved kindly give the below details:

Office version like : i.e 2007,2010,2013 .....

Excel ist 32 bit or 64 bit

Have you installed 32 bit or 64 bit AO ?

Operating system ;

Best Regards,

Shiva

Former Member
0 Kudos

Hi Purva,

in my opinion, this is a Problem of the Resolution.

Please change your DPI Settings to 100%

See also this thread https://scn.sap.com/thread/3683384

Best

Steffen