Forum Discussion

Gert_VCC's avatar
Gert_VCC
New Contributor II
10 days ago

Viewing all Metadata and values in Cube View or Spreadsheet

I am attempting to create a view in a dashboard for users to be able to see all metadata for each row with that value. Essentially I need to recreate the "Data Records" Report in the database. 

I would prefer not to recreate it in SQL via a data adapter, instead use either a Cube View or a Quick view in Spreadsheet. 

For the Cube View I can't seem to display more than 12 of the dimensions and would need 16 in the report (Cube and View aren't needed those can be in the POV).

For the Quick View in Spreadsheet putting |!prm_Entity!|  returns "#ERROR - The member filter contains unresolved parameters" instead of providing some sort of dialogue box to select the member. 

Any suggestions on how to get all dimensions into a Cube View or how to use parameters in the Member Selection in a Quick View would be greatly appreciated. 

Thanks

Cube View
Parameters
  • pranav46's avatar
    pranav46
    Contributor II
    4 days ago

    There is marketplace solution called "Unused Member Analysis" which will give list of members which does not have data in all year and let you delete member.

    If members are created part of dev and if does not have data then i would purge them using this tool instead of finding intersection.

     

    • Gert_VCC's avatar
      Gert_VCC
      New Contributor II
      4 days ago

      Hi Pranav46, thanks for the tip. The issue is more that we need to remove metadata members and need to find which intersections have data but maybe this tool will help or I can reverse engineer something from it. 

  • chul's avatar
    chul
    Contributor III
    5 days ago

    I'm interested in the use case for this and the problem/requirement that you're attempting to solve.

    • Gert_VCC's avatar
      Gert_VCC
      New Contributor II
      5 days ago

      Hi Chul, 

      The full picture is that we are engaged in a clean up of a our metadata pre-implementation and need to clear out data from specific intersections. The built in functionality does it by Cube, Entity, Scenario, and Time. We need to be able to clear specific accounts for example.

      The clearing itself will likely be straightforward, using data buffers built up from parameters selected in the Dashboard. The not straightforward issue is the presentation of the data to be cleared and then the intersections after the clear. This report is a pure validation report but we need it to display all dimensions just as the System > Tools > Data Base > Application Database > Tools > Data Records does.

      I have yet to find a good and easy approach to present all the data without using this tool. This tool is also only accessible by admins. We want to reduce the amount of admins and instead attribute roles specifically to analysts and developers in a more precise way. 

      If you or anyone has a good way to visualize data using parameters, that allows interaction with dimension (metadata) hierarchies, and allows for non-Administrator access I would really appreciate it. 

      • VishalPai's avatar
        VishalPai
        Contributor
        5 days ago

        Gert_VCC 

        You can create a data adaptor with Method Query and use method type "Data Units" and then pass parameters to it Create a dashboard with Grid View which use this data adaptor and convert parameters into combo boxes and apply that to Grid View component in dashboard

        Whenever users will select the parameters, it will bring data from data records table for those filters and dashboard can be applied with required security

        Syntax
         {Cube}{Entity}{Parent}{Cons}{Scenario}{Time}{View}{True}{Empty String or Filter Expression}
         
         Example
        {Golfstream}{|!prm_Entity!|}{}{|!prm_Cons!|}{|!prm_Scenario!|}{|!prm_Time!|}{|!prm_View!|}{True}{Account = 'Cash' And Flow = 'None'}