Microsoft Dynamics AX (Archived)

how to see sales analysis report in ax 2012 r3

(0) Share

Report

Posted on by srinivas pamidi

1,737

In Sales and marketing->Sales mangement- >sales analysis.

I am open this select the group by has sales unit and select the form date and to date

in sales unit drop look up no sales unit is showing.

i am already created sales unit in setup ->sales management ->sales unit/team.

how to check this report?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Fredrik Sætre 12,644 on at

Like (0)

Report

Have you created sales goals?

Was this reply helpful? Yes No
Suggested answer

Hariharans87 3 on at

Like (0)

Report

The report is working based on the SSAS sales and marketing cube. If you created the sales unit record after cube processed, you won't get the list in the report dialog.

So, what you need to try is process the sales and marketing cube and check report sales unit parameter.

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

how to process the sales and marketing cube?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Try to open SQL Server management studio, connect to your DB server (choose Analysis Services), you should see your databases there. Right-click and press Process.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Connect the SSAS database in SQL mangement studio, right click on the sales and marketing cube, select process menu, select full process option and click ok.

Refer manual process section into this link

technet.microsoft.com/.../dd309669.aspx

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

Hi Hariharan,

Could you please help me regarding the ssas depolyment errors.

in my Ax Application the Analysis Server Form is Look like this.

systemadministartion->setup->Business Intelligence->Analysis Services->Analysis
Server

In my SQL Server 2014 Data Base Analysis Data Base it is showing only one database Demand Forecast initial

I am trying to deploy the OLAP Server through Tools->Business Intelligence Tools->SQL Server Analysis Services Project wizard.

First deploy the Demand forecast Database but it is throwing Errors like this.

SQL server edition does not support translations. All translations (if any) have been removed
A copy of the Analysis Services project being deployed has been saved to C:\Users\test\AppData\Local\Temp\6\Demand Forecast initial1\Demand Forecast initial.dwproj.
No database named Demand Forecast initial was found on server DBSERVER.
Errors occurred while processing the Analysis Services database: Demand Forecast initial

I am Just Suprised in my data base it is showing only one data base what about the remaining data bases.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Refer into this link for deploy the default AX cubes technet.microsoft.com/.../dd309683.aspx

"You must deploy the Dynamics AX project first. After you deploy that project, you can deploy other projects."

Refer into this link for translations issue technet.microsoft.com/.../gg724140.aspx

"Language translations are supported if you use Microsoft SQL Server 2008 Enterprise Edition or Microsoft SQL Server 2008 R2 or later for your Analysis Services server. Do not include translations in the project if you are using a Microsoft SQL Server 2008 Standard Edition Analysis Services server. If you do and you get an error, you can delete the Analysis Services project in the AOT and then redeploy the Analysis Services project by using the SQL Server Analysis Services project update wizard. Alternatively, you can edit the Analysis Services project in BIDS to remove the translations. To do this, open the Analysis Services project in BIDS. Open each cube and dimension, and then click the Translations tab. Right-click the column for each translation that is not a Default translation, and then click Delete translation. After you have removed the translations, import the project into the AOT."

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

Hi Hariharan,

Please explain me detail

Please find the below link for my error list in the Ax 2012 r3

community.dynamics.com/.../204649

one more question

what happen if i am reinstall the analysis services using the AX setup?

It is impacted on my customizations?

Was this reply helpful? Yes No
Borys Bayramukov 130 on at

Like (0)

Report

Hi, Ravi

Did you solve this issue? I have the same problem with this report and other similar reports like "Pipeline analysis", "Sales vs target" etc - drop look up is empty.

And i'm wondering if it's an report error or i'm doing something wrong:)

Was this reply helpful? Yes No