BusinessObjects Board

Circumvent unsupported functions to display data

other Xcelsius - Crystal Dashboard Design
#1

Hey Gurus,

I am using the latest Crystal Dashboard, I am building a proof of concept dashboard and I have to create all the logic at the excel level.

I have a row of data that I use two unsupported functions,

I was wondering if I take the data and throw it some where else in the excel sheet and then bind my components, so it is not directly connected to the unsupported formula. Is it possible?

I have attached my test excel sheet if anyone wants to see,

Thanks :smiley:
Excel.zip (483.0 KB)

a123 (BOB member since 2011-12-28)

#2

No, that will not work. The Excel formulas are converted into ActionScript when you export the model to .swf

During the conversion there is a translation/lookup that takes place to know how to convert the formula correctly. If the formula is not support, then that means there is no lookup to translate correctly.

Does that make sense?

greg.wayne :us: (BOB member since 2010-09-28)

#3

You have made it more complicated than it needs to be. You can replace all the arrays with a Match and Index function, for example, to start off with:

=INDEX(Data!A2:A21,MATCH(Logic!A3,Data!H2:H21,0))

The cell below that will add a +1 to the match row

Then the cells beside these can use the match & index based off of these, with and If(ISError(Index…Match),"",index…match) to handle the blank rows.

And instead of using the unsupported CHAR function, use the TEXT function instead:

=TEXT(A3,"#####")

I have attached a revised spreadsheet so you can see the formulas better. My revised formulas are from G8-L19.

Hope this helps,
~Roxanne P

Sr BI Consultant
InfoSol

RoxanneP :us: (BOB member since 2006-08-07)

#4

Roxanne,

Thank you so much for your help. I really appreciate taking the time to help me out on this. I am so excited to get this to work.

I did not see the attachment?

a123 (BOB member since 2011-12-28)

#5

So sorry! Hopefully the attachment will work this time
~Roxanne
Revised 2 - Copy.zip (476.0 KB)

RoxanneP :us: (BOB member since 2006-08-07)

#6

Roxanne,

I downloaded the attachment. I am new to building logic in excel so I will go through everything that you did.

But it looks amazing, very simple, I love it ! :smiley:

You are So Awesome :+1: :smiley:

a123 (BOB member since 2011-12-28)

#7

You are very welcome!

Best of luck with your proof of concept,

~Roxanne P

Sr BI Consultant
Infosol

RoxanneP :us: (BOB member since 2006-08-07)