Error while setting server report parameters. Error message: The permissions granted to user 'Domain\User' are insufficient for performing this operation. (rsAccessDenied)

Solution : This is nothing but the Permission issue which we have to assign to the user.

Open the Report Manager website for the Reporting Services instance. By default, the URL is http://[SSRSServerName]:80/Reports

For SSRS server name go to : System administration > Setup > business intelligence > Reporting services > Report Server > 

in reporting server information Tab you will get the server name

Step 1 : Click on Dynamics ax folder 

Step 2 : Click on Folder Settings.

Step 3 :  Click on Security.

Step 4 :  Click on New Role Assignment.

Step 5 : Enter the Active Directory user name or group to assign to the DynamicsAXBrowser role.

Step 6  : Select the DynamicsAXBrowser role.

Step  7 : Click OK

I hope Now you can access ssrs reports. 

SSRS – Create child group in same column below parent

A few months ago I was developing a report and wanted a child group in the same column below its parent.  I did tried quite a few combinations of inserting and deleting of groups, rows and columns until I finally found the right way to do it.

This week I wanted a similar report and decided to write down the steps to accomplish that, otherwise simple task.  The example was made in SQL Server Reporting Services 2008 R2.

We start by creating the parent group:

Then we create the child group:

In the parent insert row inside the group above:

This is how it will look like after creating the row inside above group:

Drag and drop to move the parent group field above the child field in the next column:

Delete the, now empty, column where the parent field previously was:

You’re done!  The child group is now below its parent:

Import Main Accounts using Data Import framework | AX 2012 R3

Make sure that Data Import Export Framework install in you system. then after follow the following steps.

1- Go to General ledger --> Setup --> Charts of Accounts--> Chart of accounts.

2- Create New Chart of Accounts (chart of account, Description) then close the form.

3- Go to General ledger --> Setup --> Ledger.

4- Assign the new chart of account to the ledger(from step 2),select the fiscal calendar and the Accounting Currency then close the form.

4- Go to Data import export framework --> Setup --> Data import / export framework Parameters.

5- Click browse to select shared working directory then click Validate button then close the form.

6- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delimiter if needed.

7- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

8- in the entities form select the main Account Entity, CSV in the Sources data format, then Click the generate source file button.

9- in the wizard make sure to select the following fields:
Chartofaccounts (Chart of account code: from step 2)
MainAccountId (Account Code)
Name (Account Description)
Type (Account Type  ) 
then click Generate sample file.

10-Save the file in the shared folder you specified in step 5.

11-Open the file using MS Excel, fill the data then save the file.

12-Go back to the processing group --> entities---> Select the Sameple file path then click the generate source mapping button.

13- if the mapping done successfully Click the Preview source file button to preview the data then close the form.

14- in the processing group select the group name then click the Get staging data button to copy the file data to staging table.

15-Click OK to create job.

16-Click Run in the staging data execution form.

17-Click OK.

18-The records will be inserted in the staging.

19-In the processing group select the group name then click Copy Data to target button.

20-Select the Job ID that we created in step 15 then click OK.

21- Click Run to import data.

22-Click OK.

23-The data will be written to target.

24-Go to the main account form you will found that the accounts was imported successfully.

Note  :  If you face any issue during th process just chck the error log.

Access denied for user in Data Migration framework - Ax 2012 R3

if you get this error at time of parameter validation for DIXF.

   " Access Is denied For the user"

Solution :

-> Add the Data Import/Export Framework service account to the Microsoft Dynamics AX Data Import Export Framework Service Users local group on the computer that is running the Data Import/Export Framework service. Then restart that computer.

Hope it will work :)

Import data for ax 2012 R3 CU8 by using Test Data Transfer Tool

Import data for ax 2012 R3 CU8 by using Test Data Transfer Tool

The contoso demo data for Dynamics Ax 2012 R3 is different from previous version.we used .dat file to load demo data in previous versions. Demo data is available in .exe file.
i.e DynamicsAX2012R3DemoData.exe available in partner Resource.

 https://mbs.microsoft.com/partnersource/northamerica/deployment/downloads/product-releases/MSDYAX2012R3Release#DownloadProductandRelatedTools

To import this demo data we need  Test Data transfer Tool is available on partner resource.

Go on following link

https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)%7cQJ4JEM76642V-8-1465

OR

Download the demo data and Test Data Transfer Tool (beta)

1. Download the AX 2012 R3 demo data from the Release Page on PartnerSource.
2. Extract the demo data from the package to the database server that hosts the AX 2012 R3 business database for your environment.
3. Download the Test Data Transfer Tool (beta) tool installer from the Downloadable tools section of Microsoft Dynamics Lifecycle Services, and install it on the database server that hosts the AX 2012 R3 business database for your environment.
4. Verify that you have appropriate permissions to import data. You must have read access to the location where the demo data is stored, and in SQL Server Management Studio, permission to execute SELECT statements and BULK INSERT statements. For more information, see Install the Test Data Transfer Tool (beta) for Microsoft Dynamics AX.

To import demo data we need to do the following steps.

Step 1:

• Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location.

• The output folder will contain the files of following extension types:

1. .OUT—– data file that contains metadata for AX transactional database
2. .OutModel —- data file that contain metadata for AX model database
3. .XML —- data file that contains AX table data.

Step 2:

 Run the Test Data Transfer Tool.Exe file to install the utility.

• After successful installation, the folder will look like as shown below:

Step 3 :

• Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)

• On successful import a job will be created as shown below:

Step 4:

• Run the job <MetadataXMLGenerator(usr)>, a  meta data file will be generated and the path will be displayed in the infolog as shown in the snapshot below:

Step 5:

Copy the metadata file from the above path and paste it in [lists] folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file.

Step 6 :

Stop MS Dynamics AX service.

Step 7 :

Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).

Step 8:

• Run the following command:

Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3

C:\R3DemoData\DynamicsAXR3DemoData—— update the path (Demo Data extraced path)

DynamicsAXR3—— provide the actual database name.(Ax DB Name)

Step 9 : you need to install Test data transfer tool on SQL server and run DP command on same server. 

in case of standalone you will get the following screen.

If we enter ‘Y’, then following screen will open up describing the count for importing the table data and Error (if they come up)

• The process may take hours depending upon machine configuration.
• On successful import, start ax services again , Open AX client and data will show up.

STEP BY STEP GUIDE TO SETUP ACTIVE DIRECTORY ON WINDOWS SERVER 2012

This tutorial will explain how to install AD on server 2012 R2.

Requirement:

Minimum: 1.4 Ghz 64-bit processor

Minimum: 512 MB RAM

Minimum: 32 GB or greater

The first step is to get server 2012 install on a server. it is very similar to server 2008 install and in one of my previous posts i have discribe how to do the install in details.

Next thing we need to do is get network interfaces configured. it is obvious to use static ip address for the server. Since the server will be act as DNS server, for DNS server field you can use local host address 127.0.0.1

It is recommend to use meaning full name as the server name. in demo i renamed it as "DCPR1"

After this we are ready to start on the AD install. As per my next step i will start DNS role install first. This is not must to do, you also can install dns during the AD install. But as per best practice i always prefer to add DNS role first.
To do this we need to start "Server Manager" it can opne using shortcut on task bar or from Start > Server Manager

Then in Server Manager window click on option "Add roles and features" option.

Then it will load the "Add Role Wizard", Click next to continue

In next window keep "Role-based or feature-based installation" default selection and click on next.

In next window we can select which server to install role. in our case it will be local. so keep the default selection and click on next.

In next window it give option to select the roles. select the "DNS Server" and click on box to tick it.

Then it will prompt window to inform about the related additional features which DNS role need. click on "Add features" to continue.

In next window it gives option to select any additional feature, but in here i will keep it default. click on next to continue

Then it will give brief introduction about the DNS role, click on next button to continue

In next window it will give details about the selected features and click on "Install" to begin the installation

Then it will begin the installation and we need to wait till it completes.

Once its completes click on close.

Then you can access DNS server using server manager > tools > DNS

Now we have every thing ready for AD install. so lets load server manager again and click on "Add roles and features"

Then it will load the "Add roles and features" wizard. click on next to continue.

In next window keep "Role-based or feature-based installation" default selection and click on next.

In next window we can select which server to install role. in our case it will be local. so keep the default selection and click on next.

In next window it gives option to select the roles. select and click on tick box "Active Directory Domain Services"

Then it will prompt window to indicate the additional feature installations related to selected role. click on "Add Features" to continue.

Then in next window click on next to continue

In next window it will give option to select addtional feature to install. but i will keep the default selection. click next to install.

In next window it give brief description about the AD service. click on next to continue.

In next window it gives brief about the installation. click on "install" to start the installation.

In next window it will begins the service install and we have to wait till it finish.

Once it finish click on "close" to exit from the wizard. then next step is to reboot the server to complete the installation.

After that completes we need to start on the DC setup. to start that open the "Server Manager" and click Task flag on right hand corner. then it will list option as below picture. click on "promote this server to a domain controller" option ( highlighted with yellow in picture)

Then it starts the DCPROMO wizard. on the first window since its going to be new forest i have selected option "Add a new forest" and i typed the domain name "contoso.com" which i will be using on the forest. once fill the info click on "next" to continue.

In next window we can select the forest and domain functional levels. i will keep it default. then in domain controller capabilities its by default selected DNS server and Global Catalog as its first DC in the forest. then we need to defined password to use in DC recovery. click on next to continue.

In next window it will give following error but it can be ignore. click on next to continue.

In next window it ask for the netbios name. we can keep it default and click on next to continue.

In next window it give option to change file paths for AD database, log files and SYSVOL files. we can change the paths or keep them defaults. once changes are done click on next to continue.

In next window it gives description about the installation. click on next to continue.

In next window it will run system check and verify system is compatible with the selected installation. once test completes successfully click on install button to begin the installation. if its passes any critical errors those needs to be address before the installation begin.

then it will start the install and we need to wait till it finishes.

Once its complete the install it will automatically reboot the server.

Once server is rebooted log in to server using domain admin credentials.

In our demo it will be in format of

user : contoso\Administrator

password : XXXXXXXXX

Once login, load the "Server manager" and click on "AD DS" option in right hand list. then select and right click as showed in screenshot to start with AD configuration.

Now we successfully completed with the DC setup on server 2012 R2.

http://www.rebeladmin.com/2014/07/step-by-step-guide-to-setup-active-directory-on-windows-server-2012/