top customers by ytd sales report parameter

(0) Share

Report

Posted on by mahmoud kheder

190

dears,

I want to open the top customers by ytd sales report in sales and market module.
this report gives me the validation error
field 'year:' must be filled in.

but it's disabled or read only field. how to change it or how to fill in this field

am i missing any sittings or setup to run this report?

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

The report parameters are based on the "Accounts receivable" cube.

Probably you have deploy the default cube, but not processed.

Take a look at technet.microsoft.com/.../dd309683.aspx

Was this reply helpful? Yes No
Bilal Issa 4,370 on at

Like (0)

Report

Hi Mahmoud,

you need to process dynamics analysis database .

Regards,

Bilal

Was this reply helpful? Yes No
mahmoud kheder 190 on at

Like (0)

Report

Was this reply helpful? Yes No
mahmoud kheder 190 on at

Like (0)

Report

Hi Bilal,

thanks for reply, i did the process to analysis database but the report still not working.

all the report related to the analysis cube dose not work. it have the same message depending on parameters.

Was this reply helpful? Yes No
Bilal Issa 4,370 on at

Like (0)

Report

Hi Mahmoud,

did processing analysis database finished successfully ?

Regards,

Bilal

Was this reply helpful? Yes No
mahmoud kheder 190 on at

Like (0)

Report

i was deployed and processed all cubes but still didn't work.

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Mahmoud

Try to browse the "Accounts receivable" cube from Excel.

You are able to see some data ?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

do you have any customization related to this report.

if yes please review your customization

if not try to redeploy the report

consider clearing the caches before running the report.

Please verify and update us with your findings

Was this reply helpful? Yes No
mahmoud kheder 190 on at

Like (0)

Report

Hi Denis,

yes, i am able to see data from Excel.

Was this reply helpful? Yes No
mahmoud kheder 190 on at

Like (0)

Report

Hi Nitesh,

I didn't have any customization in this report.

now i deploy and process SSAS then clearing cashes i get this error related to fiscal calendar

Query (12, 2) The dimension '[Transaction date - fiscal calendar]' was not found in the cube when the string, [Transaction date - fiscal calendar].[Year].[All], was parsed.

when i open this report from reporting server the field year: is empty and it didn't return anything when click veiw report

Was this reply helpful? Yes No