The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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
AJ's avatar
AJ
New Contributor III
4 years ago

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

  • ckattookaran's avatar
    ckattookaran
    Valued Contributor
    4 years ago

    I hear you, it is stored in a table called DataCellDetail, join those with the member tables and that should give you the intersections. Now the details are stored in XmlData, you'll need an XMLDocument and read the nodes you want.

    <LineItemList>
    <LastEditedUserName>Admin</LastEditedUserName>
    <LastEditedDateTime>2021-11-16T16:55:39.152342Z</LastEditedDateTime>
    <LineItems>
    <LineItem>
    <LineItemType>Default</LineItemType>
    <Amount>100</Amount>
    <AggregationWeight>1</AggregationWeight>
    <Classification />
    <Description>test</Description>
    </LineItem>
    <LineItem>
    <LineItemType>Default</LineItemType>
    <Amount>20</Amount>
    <AggregationWeight>1</AggregationWeight>
    <Classification />
    <Description />
    </LineItem>
    </LineItems>
    </LineItemList>

     

    • KeithBerry's avatar
      KeithBerry
      Icon for OneStream Employee rankOneStream Employee
      4 years ago

      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
        Icon for OneStream Employee rankOneStream Employee
        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