Using Cell detail in cube view ,forms and reports

There you go, you got three options. Now all you got to do is weigh in which one and how you want to use it. If you are going with a dashboard, all 3 are viable options. However, I would go with the business rule approach - this one gives you more control. You can decide which columns you want to show and return only those in the DataAdapter. 

Second and most preferred way will be to use the method query to pull it in an adapter and use it. However, you will now pull all the details (wanted and unwanted) and then suppress them on the dashboard end. This does have a performance impact (I've tested this by bringing more columns than I need and suppressing them on a grid view). That is the best option if you are ok with the performance impact (it probably won't be that big of a deal depending on your requirement). If not, go with the rule.

Now, even though I did talk about the table, I would love to erase that option. Can it be done? Absolutely, should it be done that way? No way!!! 🤣🤣

Hi, here is how to get the parameter:

Dim ActMonth As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "ActMonth")

Cheers

Hi Mark,

Thanks for your update , just wanted to confirm in your example ActMonth is parameter name ?

Thanks

AJ

Hi all

GetLiteralParameterValue only gives you literal parameters, you won't get the dynamic parameters from drop down boxes. If you need the dynamic information you can use in Dashboard Extender business rules the args object: args.SelectionChangedTaskInfo.CustomSubstVars

When you talk about cell details, are you looking for annotations on a particular cell?

What are you doing with the parameter? Depending on what you are doing with the parameter you can either pass the parameter to a function. Without knowing what you are planning to do with the parameter, won't be able to help.

Hi Celvin,

Thanks for your update.

I am trying to create to cube view and DE form where in user will enter the data using right click on editable cell and using cell details option , user will enter the data. In this case requirement is to get different classification also to be chosen from list. ( If I create a another dashboard parameter with the name CellDetailClassifications , I am able to get the classification list available )

Using quickview reporting of cell details is possible , however just wanted to check if there is any existing report which can be used to get entered cell detail information.

Yes , one of the column in the form uses annotations and based on "Text" based selection , another column in the form/CV will drive the calculation.

Regards

AJ

ChristianW & ckattookaran 

 Just checking if we can copy cell details (Amount, aggregation Weight, Classification and description from period 1 to Period 2 via business rule?

Thanks

AJ

Thank you All 🙂

I will try with method query and business rule approach ...and test it.