Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we use expressions from Excel in the chart?.....
Suppose i hav an excel containing two fields
Selection Expression
CMC sum(Sales)
Product count(Product)
...................................
..............................
Im using only one dimension for example : Customer.
The Data modelling also having the fields Sales and Product
Now i want to use the expressions from the Excel in the chart .
when i select CMC in the field Selection the expression sum(Sales) should show the result for the dimension Customer.
Similarly for Prodcut the expression count(Product) should show the result.so on..
Can we Map the Fields Sales and Product in the data modelling to the Expression field values Sales and Product ( from Excel)..
regards
Ashok Kumar J
I have tested this but I don't think you can use the value from your Excel sheet as a chart expression. I can't get it to see the value as an expression. The chart just displays =sum(Sales) instead of the expression result.
Maybe you can try the following:
Regards, Sander
Hi Ashok,
When you transform (rotate it in the Table Files wizard) your Excel sheet making CMC and product fieldnames and the expressions values you can link these fields to the ones in your datamodel. Then you can use the expression values as value linked to you customer dimension.
Is this what you mean?
Regards, Sander
No. We cannot link the Excel to the data model, becoz it has expressions from diff tables..
i want to know whether we can use expreesion from excel in the chart?
Regards
Ashok Kumar
Ok.. So you want to load a value as an expression.. Can't you just say
= IF([Selection]='CMC', ' = ' & [Expression])
in your chart expression?
Sander
Hi
U didnt get wat i say....
Im going to use an Excel for some expressions in the chart. so that the End User can change only the expression in the excel instead of going into the chart and add expression. so the Sales in sum(Sales) cannot be linked to the Field in the data model field Sales. it is treating it as text instead of field.
Regards
Ashok Kumar
I have tested this but I don't think you can use the value from your Excel sheet as a chart expression. I can't get it to see the value as an expression. The chart just displays =sum(Sales) instead of the expression result.
Maybe you can try the following:
Regards, Sander
Extract the 2 fields selection, expression from the excel.
This become independent table.
Write the macro to achieve this. You can get the help from the API guide for dynamically Add/Removing expression and dimension on chart objects.
Map that macro agaist OnSelect of "selection" field from the menu Settings -> Document properties -> Macro tab.
Hi all
we got the solution.. Thanks Sander & Yoga for ur responses..
It works.. even without using macro...
Assiging the field Expression (from Excel) to a Variable inside the application and then
using the Variable inside the chart by $(Variable) worked .
Regards
Ashok Kumar J
See attached file.
/Karl