Unanswered

Costumized View into Gallery

(0) Share

Report

Posted on by marieRasmussen1

I am building an app based on an existing data warehouse. This means that tables are divided into dimension and fact tables.

I am successful in embedding dimension logic in the fact table by using a Lookup function. This means that I can create a view that use data from table 1:dim_product (columns: (1)Product name, (2)product id) and combine it with facts from table 2:fact_sales (Columns(1)Unitprice, (2)lineamount, (3)quantity).

Now, I will very much like to show this view in a gallery in a Canvas app.

Is there a way I can implement a view in a gallery?

Picture shows structure of the tables and relations

Categories:

Using Apps Using Formulas

All responses (3)

Answers (0)

BideyYusuf 387 on at

Like (0)

Report

Re: Costumized View into Gallery

Hi @marieRasmussen1 Yes its possible. You might need to duplicate the gallery, place it on your screen, then use filter function to filter the record base on the lookup table values existing in Fact Sales Table
marieRasmussen1 2 on at

Like (0)

Report

Re: Costumized View into Gallery

All my table is imported to Dataverse. So, to give you the more detailed explanation about my tables:
My table Dim_product is joined into fact_sales from the beginning. I have to use a lookUp column in fact_sales to dim_product so the table identify linked values. The lookup column in dataverse have the condition that Dim_Product_id from fact_sales sould be equal to Dim_Product_id in Dim_product table.
Therefore, I'm able to create following customized view with related table from both dataverse tables:

This view, I will like to implement in a gallery in a canvas app
BideyYusuf 387 on at

Like (0)

Report

Re: Costumized View into Gallery

Hi, @marieRasmussen1 This is quite possible to implement. and it also depends on the datasource you intend to use. Dataverse would be very good to achieve this, Sharepoint too can do it.
fact Sales is the major Table, with the 2 columns "Dim-Customer-id" & "Dim-Product-id" being a lookup to Dim-Customer & Dim-Product Table respectively.

Must you show these 2 supporting table as a gallery. because i believe the Gallery should be built on FACT SALES TABLE alone.