Forum Discussion

AJ's avatar
AJ
New Contributor III
4 years ago

Using Cell detail in cube view ,forms and reports

Hello Few of questions on using cell details 1. How can we add different classifications for data entry via cell details ?  I have created dashboard parameter for same , however its not reflectin...
User Interface
kberry's avatar
kberry
New Contributor III

There is also a method query to retrieve cell detail. Create a data adapter and you can build your own report using Studio, BI Viewer or a TableView:

 

Parameters for method type 'DataCellDetail' should include {Cube Name}{Entity Filter}{Scenario Name}{Time filter}{Account Filter}{Flow Filter}{IC Filter}{UD1 Filter}{UD2 Filter}{UD3 Filter}{UD4 Filter}{UD5 Filter}{UD6 Filter}{UD7 Filter}{UD8 Filter}{Filter}, each enclosed within curly braces.

Example: {Cube}{E#US.Base}{Scenario}{T#2015M1}{}{}{}{}{}{}{}{}{}{}{}{Empty String or Filter Expression}.

 

 

 

ChristianW's avatar
ChristianW
Valued Contributor
4 years ago

You also can get the line items using a BRAPI function:

Dim objDataCellInfoUsingMemberScript As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cubeName, memberScript)
objDataCellInfoUsingMemberScript.DataCellEx.DataCellDetail.LineItems.LineItems