Passing Data From a Parent to Child SWF (Flash Variables)

Due to performance limitations within Xcelsius, it can be difficult to build large scale dashboards that are easy to manage. Fortunately, Xcelsius comes equipped with components that makes it easier to create a single “Parent” SWF which can load multiple “Child” SWFs inside itself. Perhaps the biggest challenge with this design architecture is enabling the “Parent” SWF to communicate with the “Child” SWF.

Luckily, with the use of Flash Variables and the SWF loader component, we can easily overcome this challenge.

How to do it:

1. Create your child.xlf

2. Establish a cell where your parameter will be passed. I used cell E6 in my example

3. Access the data manager within the child.xlf and add a Flash Variables connection

4. Add a range and give it a name. In my example I named the range “salesman”

5. Select the range in which the data parameter will be passed. Cell E6 is the range in my example

6. Create your parent.xlf

7. Setup a sheet within your parent.xlf as follows:

a) Enter the URL where your will store your child.swf in cell B5

b) Enter the name of the range that you used in your child.swf in cell B7 “salesman”

c) Reserve cell B9 for the parameter that is going to be passed

d) Enter the following formula in cell B11: =B5&”?”&B7&”=”&B9

8. Add a component to input your parameter – I chose to use a list box for my example

9. Bind the output destination of your component to cell B9

10. Add a SWF Loader component to the dashboard

11. Bind the Source URL to cell B11

There you have it. Although my example is fairly simple, this should get you moving in the right direction to developing larger scale dashboard applications that are easier to manage.

As always, feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Data Sharer Component)

In my previous post I demonstrated how to pass data from a parent to child SWF with the use of Flash Variables and the SWF Loader component. Today, I’m going to demonstrate how to accomplish the same functionality leveraging a free add-on component from Inovista.com called the “Data Sharer”.

One of the noticeable difference in this solution compared to the use of Flash Variables is that the child SWF does not have to load and initialize each time the parameter is changed.

How to do it:

1. Go to Inovista.com and download the free data sharer component

2. Add the data sharer component with Xcelsius’ Add-On Manager GUI or see Kalyan’s post “Using the command-line version of the Add-On Manger in Xcelsius 2008” to add using command line

3. Using the same child.xlf as in my previous example I have kept the same cell (E6) reserved for my parameter

4. Next add the data sharer component found under the “Inovista Other” category in your components list. Note that the component will not be visible at run time.

5. Give the data sharer a connection name. In my example I have used “salesman”

6. Check the “Import Values” box

7. Select the range of cells for  the “Import Data Cells”. In my example it is cell E6

8. Save and export your child SWF

9. Using the same parent.xls as in my previous example I have made a few changes to the underlying excel sheet.

a. Cell B5 should have the URL to your child SWF (Note that your SWF Loader Component will link to this URL)

b. Cell B7 should be reserved for the parameter that is going to be passed

10. Add the data sharer component to your canvas

11. Use the same connection name that you used in your child SWF. I used “salesman” in my example

12. Check the “Transmit Values” box

13. Select the range of cells for the “Transmit Data Cells”. In my example it is cell B7

14. Save and export your parent SWF. Note that the parent and child SWF should be located on the same server or file directory.

There you have it. Passing data from a Parent to Child SWF leveraging what I feel to be one of the best free components available to the Xcelsius community. There are a few quirks with this component so be sure to read the supporting documentation when implementing into a more complex model.

As always, please feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Flash Variables)

Due to performance limitations within Xcelsius, it can be difficult to build large scale dashboards that are easy to manage. Fortunately, Xcelsius comes equipped with components that makes it easier to create a single “Parent” SWF which can load multiple “Child” SWFs inside itself. Perhaps the biggest challenge with this design architecture is enabling the “Parent” SWF to communicate with the “Child” SWF.

Luckily, with the use of Flash Variables and the SWF loader component, we can easily overcome this challenge.

How to do it:

1. Create your child.xlf

2. Establish a cell where your parameter will be passed. I used cell E6 in my example

3. Access the data manager within the child.xlf and add a Flash Variables connection

4. Add a range and give it a name. In my example I named the range “salesman”

5. Select the range in which the data parameter will be passed. Cell E6 is the range in my example

6. Create your parent.xlf

7. Setup a sheet within your parent.xlf as follows:

a) Enter the URL where your will store your child.swf in cell B5

b) Enter the name of the range that you used in your child.swf in cell B7 “salesman”

c) Reserve cell B9 for the parameter that is going to be passed

d) Enter the following formula in cell B11: =B5&”?”&B7&”=”&B9

8. Add a component to input your parameter – I chose to use a list box for my example

9. Bind the output destination of your component to cell B9

10. Add a SWF Loader component to the dashboard

11. Bind the Source URL to cell B11

There you have it. Although my example is fairly simple, this should get you moving in the right direction to developing larger scale dashboard applications that are easier to manage.

As always, feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Data Sharer Component)

In my previous post I demonstrated how to pass data from a parent to child SWF with the use of Flash Variables and the SWF Loader component. Today, I’m going to demonstrate how to accomplish the same functionality leveraging a free add-on component from Inovista.com called the “Data Sharer”.

One of the noticeable difference in this solution compared to the use of Flash Variables is that the child SWF does not have to load and initialize each time the parameter is changed.

How to do it:

1. Go to Inovista.com and download the free data sharer component

2. Add the data sharer component with Xcelsius’ Add-On Manager GUI or see Kalyan’s post “Using the command-line version of the Add-On Manger in Xcelsius 2008” to add using command line

3. Using the same child.xlf as in my previous example I have kept the same cell (E6) reserved for my parameter

4. Next add the data sharer component found under the “Inovista Other” category in your components list. Note that the component will not be visible at run time.

5. Give the data sharer a connection name. In my example I have used “salesman”

6. Check the “Import Values” box

7. Select the range of cells for  the “Import Data Cells”. In my example it is cell E6

8. Save and export your child SWF

9. Using the same parent.xls as in my previous example I have made a few changes to the underlying excel sheet.

a. Cell B5 should have the URL to your child SWF (Note that your SWF Loader Component will link to this URL)

b. Cell B7 should be reserved for the parameter that is going to be passed

10. Add the data sharer component to your canvas

11. Use the same connection name that you used in your child SWF. I used “salesman” in my example

12. Check the “Transmit Values” box

13. Select the range of cells for the “Transmit Data Cells”. In my example it is cell B7

14. Save and export your parent SWF. Note that the parent and child SWF should be located on the same server or file directory.

There you have it. Passing data from a Parent to Child SWF leveraging what I feel to be one of the best free components available to the Xcelsius community. There are a few quirks with this component so be sure to read the supporting documentation when implementing into a more complex model.

As always, please feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Flash Variables)

Due to performance limitations within Xcelsius, it can be difficult to build large scale dashboards that are easy to manage. Fortunately, Xcelsius comes equipped with components that makes it easier to create a single “Parent” SWF which can load multiple “Child” SWFs inside itself. Perhaps the biggest challenge with this design architecture is enabling the “Parent” SWF to communicate with the “Child” SWF.

Luckily, with the use of Flash Variables and the SWF loader component, we can easily overcome this challenge.

How to do it:

1. Create your child.xlf

2. Establish a cell where your parameter will be passed. I used cell E6 in my example

3. Access the data manager within the child.xlf and add a Flash Variables connection

4. Add a range and give it a name. In my example I named the range “salesman”

5. Select the range in which the data parameter will be passed. Cell E6 is the range in my example

6. Create your parent.xlf

7. Setup a sheet within your parent.xlf as follows:

a) Enter the URL where your will store your child.swf in cell B5

b) Enter the name of the range that you used in your child.swf in cell B7 “salesman”

c) Reserve cell B9 for the parameter that is going to be passed

d) Enter the following formula in cell B11: =B5&”?”&B7&”=”&B9

8. Add a component to input your parameter – I chose to use a list box for my example

9. Bind the output destination of your component to cell B9

10. Add a SWF Loader component to the dashboard

11. Bind the Source URL to cell B11

There you have it. Although my example is fairly simple, this should get you moving in the right direction to developing larger scale dashboard applications that are easier to manage.

As always, feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Data Sharer Component)

In my previous post I demonstrated how to pass data from a parent to child SWF with the use of Flash Variables and the SWF Loader component. Today, I’m going to demonstrate how to accomplish the same functionality leveraging a free add-on component from Inovista.com called the “Data Sharer”.

One of the noticeable difference in this solution compared to the use of Flash Variables is that the child SWF does not have to load and initialize each time the parameter is changed.

How to do it:

1. Go to Inovista.com and download the free data sharer component

2. Add the data sharer component with Xcelsius’ Add-On Manager GUI or see Kalyan’s post “Using the command-line version of the Add-On Manger in Xcelsius 2008” to add using command line

3. Using the same child.xlf as in my previous example I have kept the same cell (E6) reserved for my parameter

4. Next add the data sharer component found under the “Inovista Other” category in your components list. Note that the component will not be visible at run time.

5. Give the data sharer a connection name. In my example I have used “salesman”

6. Check the “Import Values” box

7. Select the range of cells for  the “Import Data Cells”. In my example it is cell E6

8. Save and export your child SWF

9. Using the same parent.xls as in my previous example I have made a few changes to the underlying excel sheet.

a. Cell B5 should have the URL to your child SWF (Note that your SWF Loader Component will link to this URL)

b. Cell B7 should be reserved for the parameter that is going to be passed

10. Add the data sharer component to your canvas

11. Use the same connection name that you used in your child SWF. I used “salesman” in my example

12. Check the “Transmit Values” box

13. Select the range of cells for the “Transmit Data Cells”. In my example it is cell B7

14. Save and export your parent SWF. Note that the parent and child SWF should be located on the same server or file directory.

There you have it. Passing data from a Parent to Child SWF leveraging what I feel to be one of the best free components available to the Xcelsius community. There are a few quirks with this component so be sure to read the supporting documentation when implementing into a more complex model.

As always, please feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Data Sharer Component)

In my previous post I demonstrated how to pass data from a parent to child SWF with the use of Flash Variables and the SWF Loader component. Today, I’m going to demonstrate how to accomplish the same functionality leveraging a free add-on component from Inovista.com called the “Data Sharer”.

One of the noticeable difference in this solution compared to the use of Flash Variables is that the child SWF does not have to load and initialize each time the parameter is changed.

How to do it:

1. Go to Inovista.com and download the free data sharer component

2. Add the data sharer component with Xcelsius’ Add-On Manager GUI or see Kalyan’s post “Using the command-line version of the Add-On Manger in Xcelsius 2008” to add using command line

3. Using the same child.xlf as in my previous example I have kept the same cell (E6) reserved for my parameter

4. Next add the data sharer component found under the “Inovista Other” category in your components list. Note that the component will not be visible at run time.

5. Give the data sharer a connection name. In my example I have used “salesman”

6. Check the “Import Values” box

7. Select the range of cells for  the “Import Data Cells”. In my example it is cell E6

8. Save and export your child SWF

9. Using the same parent.xls as in my previous example I have made a few changes to the underlying excel sheet.

a. Cell B5 should have the URL to your child SWF (Note that your SWF Loader Component will link to this URL)

b. Cell B7 should be reserved for the parameter that is going to be passed

10. Add the data sharer component to your canvas

11. Use the same connection name that you used in your child SWF. I used “salesman” in my example

12. Check the “Transmit Values” box

13. Select the range of cells for the “Transmit Data Cells”. In my example it is cell B7

14. Save and export your parent SWF. Note that the parent and child SWF should be located on the same server or file directory.

There you have it. Passing data from a Parent to Child SWF leveraging what I feel to be one of the best free components available to the Xcelsius community. There are a few quirks with this component so be sure to read the supporting documentation when implementing into a more complex model.

As always, please feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Data Sharer Component)

In my previous post I demonstrated how to pass data from a parent to child SWF with the use of Flash Variables and the SWF Loader component. Today, I’m going to demonstrate how to accomplish the same functionality leveraging a free add-on component from Inovista.com called the “Data Sharer”.

One of the noticeable difference in this solution compared to the use of Flash Variables is that the child SWF does not have to load and initialize each time the parameter is changed.

How to do it:

1. Go to Inovista.com and download the free data sharer component

2. Add the data sharer component with Xcelsius’ Add-On Manager GUI or see Kalyan’s post “Using the command-line version of the Add-On Manger in Xcelsius 2008” to add using command line

3. Using the same child.xlf as in my previous example I have kept the same cell (E6) reserved for my parameter

4. Next add the data sharer component found under the “Inovista Other” category in your components list. Note that the component will not be visible at run time.

5. Give the data sharer a connection name. In my example I have used “salesman”

6. Check the “Import Values” box

7. Select the range of cells for  the “Import Data Cells”. In my example it is cell E6

8. Save and export your child SWF

9. Using the same parent.xls as in my previous example I have made a few changes to the underlying excel sheet.

a. Cell B5 should have the URL to your child SWF (Note that your SWF Loader Component will link to this URL)

b. Cell B7 should be reserved for the parameter that is going to be passed

10. Add the data sharer component to your canvas

11. Use the same connection name that you used in your child SWF. I used “salesman” in my example

12. Check the “Transmit Values” box

13. Select the range of cells for the “Transmit Data Cells”. In my example it is cell B7

14. Save and export your parent SWF. Note that the parent and child SWF should be located on the same server or file directory.

There you have it. Passing data from a Parent to Child SWF leveraging what I feel to be one of the best free components available to the Xcelsius community. There are a few quirks with this component so be sure to read the supporting documentation when implementing into a more complex model.

As always, please feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Passing Data From a Parent to Child SWF (Flash Variables)

Due to performance limitations within Xcelsius, it can be difficult to build large scale dashboards that are easy to manage. Fortunately, Xcelsius comes equipped with components that makes it easier to create a single “Parent” SWF which can load multiple “Child” SWFs inside itself. Perhaps the biggest challenge with this design architecture is enabling the “Parent” SWF to communicate with the “Child” SWF.

Luckily, with the use of Flash Variables and the SWF loader component, we can easily overcome this challenge.

How to do it:

1. Create your child.xlf

2. Establish a cell where your parameter will be passed. I used cell E6 in my example

3. Access the data manager within the child.xlf and add a Flash Variables connection

4. Add a range and give it a name. In my example I named the range “salesman”

5. Select the range in which the data parameter will be passed. Cell E6 is the range in my example

6. Create your parent.xlf

7. Setup a sheet within your parent.xlf as follows:

a) Enter the URL where your will store your child.swf in cell B5

b) Enter the name of the range that you used in your child.swf in cell B7 “salesman”

c) Reserve cell B9 for the parameter that is going to be passed

d) Enter the following formula in cell B11: =B5&”?”&B7&”=”&B9

8. Add a component to input your parameter – I chose to use a list box for my example

9. Bind the output destination of your component to cell B9

10. Add a SWF Loader component to the dashboard

11. Bind the Source URL to cell B11

There you have it. Although my example is fairly simple, this should get you moving in the right direction to developing larger scale dashboard applications that are easier to manage.

As always, feel free to download the source files.

If you enjoyed this post, make sure you subscribe to my RSS feed!