Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Table source in new Aggregations preview

Hi,   I'm trying out the new Aggregations feature in the September release and I'm wondering how to bring in the table which will be used as the aggregations table.  For example, I have a single ta...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks.  The official documentation has a note stating:

     

    "Note

    The Sales Agg table is just another table, so it has the flexibility of being loaded in a variety of ways. For example, aggregation can be performed in the source database using ETL/ELT processes"

     

    and the Prologika post states:

     

    "As a first step for setting up aggregations, you need to add a summarized table. Unlike MD, you are responsible for designing, populating and maintaining this table"

     

    I have therefore created a view in the SQL Database which SUMs and GROUP BY the necessary dimension key.

     

    All is working as expected now.

     

    Thanks

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous

       

      Glad to hear the documents are helpful, please accept the helpful reply as solution, that way, other community members will easily find the solution when they get same issue.

       

      Regards,

      Cheire