Requesting for answers for few scenarios

[sridhar_sigired]

Dear Community,

Here i have few scenarios, can you please help me on this?

1. If i select a year, the filtering should be done for next four years along with selected year.

        Ex: I have a bar chart for 10 years, if i select 2005, then data should be filter from 2005 to 2009.

     2. I have two tables with below fields.

             Table1 (Emp table)   Table2(Emp address table)

              EMPID                   EMPID

              EMPNAME             EMPADD1

               DEPTCODE           EMPADD2

                                            EMPADD3

     Each employee has multiple addresses (Many to Many relationship) and same address is available for different employees.

     I want to get join these tables, how can we do it and how can i remove the redundancy.

     3. What are the parametric variables and where do we use them?

      4. I have use data in my Application with several charts, for last chart it is taking much time. How can i optimize it?

         Can you please tell me the ways to do it?

Thanks for spending your valuable time on this.

Thanks alot.

Sridhar.

[JonnyPoole]

For #1 you can use a trigger that triggers a 'select in field action' to select the next 4 years as well.

Take a look below and test the attached if you need

[sridhar_sigired]

Thanks Jonathan.

Friends, can anyone help on remaining questions?

Thanks a lot.

Sridhar.

[#4]

1) use set analysis u can achieve this scenario

create a variable v1=max(year)

sum({<year={'=>(v1) <=(v1+4)'} Sales)

2) if Empadd1,empadd2,empadd3 all are same for each EmpId

then join two tables with EmpId and Remove other Add2 nd Add3

Table1 (Emp table)   Table2(Emp address table)

              EMPID                   EMPID

              EMPNAME             EMPADD1

               DEPTCODE        

4) if you have any heavy calculation in chart better to do it in script like string functions

[sridhar_sigired]

Thanks for your reply Rakesh.

Hear each emp has multiple different addresses Rakesh. And also duplicate addresses are available for different emp.