Forum Discussion

Marco's avatar
Marco
Contributor II
2 years ago

What is the table from which the information of the QView comes from? (sql question)

I'm running a SQL query to display the data as if it were a QView, but I realized that the table I was using didn't contain the values it should. SELECT EntityId, ...
Finance
Marco's avatar
Marco
Contributor II
2 years ago

Yes, a cube view, but I want to know if there is a way to do it even from a business rule, that is, a business rule that gives me the data of a cube view or the way that the functionality of Excel does.

JackLacava's avatar
JackLacava
Community Manager
2 years ago

You can get data from cubeviews in a few different ways. What you choose will depend on what you want the output to look like.

  1. If you're building a Dashboard or Report, there are two types of Data Adapter you can use - Cube View and Cube View MD (I'd recommend the latter). You wire that to a Grid or a Pivot Grid and you're done, no code necessary.
  2. If you need to extract data to a text file, in a BR you can use Brapi.Import.Data.FdxExecuteCubeView or FdxExecuteCubeViewTimePivot. They are the fastest way to retrieve the same numbers you'd get from a CV, but they do require you to pass quite a few parameters.
  3. A hybrid approach, slightly slower than 2 but easier to manage for non-coders, is to set up a Data Adapter like in 1, and then call it from a rule using a basic call of BRApi.Dashboards.Process.GetAdoDataSetForAdapter. This way you can easily change CV and parameters later on, without having to touch the rule.
  4. If you need to extract data to Excel, you can use approach 2 or 3 from a Table View, or you can use BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile.
  • Marco's avatar
    Marco
    Contributor II
    2 years ago

    How could I do something like quick views in Excel to display information on a dashboard? Since I have more filters than what the cube view allows me (for the row).

     

    • JackLacava's avatar
      JackLacava
      Community Manager
      2 years ago

      I'm not sure I understand the question, but if it's about building filters on a Dashboard, you'll have to investigate Bound Parameters and general Dashboard design. It's a vast topic, there is a book about it.