locked
LightSwitch: We Now Have Our 'Killer App' RRS feed

All replies

  • Mike,

    I was really impressed when I saw it yesterday on the MS website.  Do you please know if it's possible to use data from multiple tables/entities in the ComponentOne's OLAP for LightSwitch?

    LightSwitch is definitely going to be a game changer.

     

    The videos here (thanks to Ron Wal) http://www.microsoft.com/showcase/en/us/details/92b0dc8b-6904-4a80-bd9a-e4b59c6e1fc4 are very encouraging and a great habinger of the things to come and the immense potrntial LS possesses. 

    I had to watch the ComponentOne video 3 or 4 times yesterday :) 

    Sunday, July 24, 2011 2:46 PM
  • Mike,

    I was really impressed when I saw it yesterday on the MS website.  Do you please know if it's possible to use data from multiple tables/entities in the ComponentOne's OLAP for LightSwitch?

    LightSwitch is definitely going to be a game changer.

     

    The videos here (thanks to Ron Wal) http://www.microsoft.com/showcase/en/us/details/92b0dc8b-6904-4a80-bd9a-e4b59c6e1fc4 are very encouraging and a great habinger of the things to come and the immense potrntial LS possesses. 

    I had to watch the ComponentOne video 3 or 4 times yesterday :) 


    Yes, see:

    Using OLAP for LightSwitch

    Basically you only analyze one Table at a time, but you see data from any related table. So if ALL your tables are related (and normally they always should be), then you can analyze all your tables at once.


    Make Them Ask: That's a LightSwitch App?

    http://LightSwitchHelpWebsite.com

    Sunday, July 24, 2011 4:16 PM
  • Thanks Mike.

    So my question is if you have the relationships as follows (using northwind)

    ------------------------------------------------------------------------------------

                         Employees   

                               |

                               |

                               v

    Customer ---> Orders -------> OrderDetails----------> Products

     

    Which table would you use to be able to analyze the data using any of the attributes from any of these related tables?

    One other point I noted is that there doesn't appear to have a print preview (small issue, but would have been nice to have)

    Also. it would have been 'nice to have' the ability to export the grid to excel.  Still playing with it.  Thanks.


    Sunday, July 24, 2011 4:51 PM
  • In your example I would analyze the Orders table. That is the "center" of it all.

    I updated the article at:

    http://lightswitchhelpwebsite.com/Blog/tabid/61/EntryId/46/Using-OLAP-for-LightSwitch.aspx

    to show how you can create computed fields to "surface" some of the values you may need that are not showing up. For example, to show monetary total of the products that each employee sold.

    image

    I also added a very brief glimpse showing how all the normal LightSwitch filtering still works. In my example, you can limit the OLAP to a single sales person.


    Make Them Ask: That's a LightSwitch App?

    http://LightSwitchHelpWebsite.com

    Sunday, July 24, 2011 5:20 PM
  • Thanks again for the example and quick response.

    That will mean we would probably have to pull any data that we would like to use in the analysis from any of the related tables onto the 'central' table.  That's what I am trying to avoid :)

    For instance, if I want to analyze the above northwind relatinship I cited earlier using the Product Category, it would mean I have to pull the category field from the product table onto the orders table.

    Btw, there was another extension video about generating RIA Services on the fly?  I need to go back and view the demo videos again to see if that was correct.

    Sunday, July 24, 2011 5:54 PM
  • Michael,

    Nice Olap Control - KIller App, I don't think I'd go that far. Use it? Probably for some customers. Haven't investigated the pricing and licensing details yet. Thanks for pointing me in this direction and reminding me of the previously posted link.

    In days of yore I was using an Oracle product called Discoverer. It had similar functionality. There have been a plethora of other OLAP view / reporting tools since. OK One thing I'll give you, they don't work inside LightSwitch. Though I do think there are some Silverlight based products around.

    Love your enthusiasm, Keith

    Sunday, July 24, 2011 11:10 PM
  • Michael,

    Nice Olap Control - KIller App, I don't think I'd go that far.

    If you had a client that needed to analyze sales data, you could just have them use Excel (this is what most people do), or you could charge them a lot of money to build out a full blown app using Silverlight, Flash, HTML 5 ect.

    Or you could build them an app in LightSwitch in less than one hour.

    Or they could just do it themselves.

    If that doesn't define a "Killer App" I don't know what does Hahaha


    Make Them Ask: That's a LightSwitch App?

    http://LightSwitchHelpWebsite.com

    Monday, July 25, 2011 12:36 AM
  •  

    For instance, if I want to analyze the above northwind relatinship I cited earlier using the Product Category, it would mean I have to pull the category field from the product table onto the orders table.

     

    Remember I downloaded this control for the first time, AND wrote an article about it in one hour. That does not make me an expert... just shows that any tool that allows you to do that is truly "idiot proof".

    So, it appears to me that you can analyze any field that has a relation, so with Orders you automatically get all the tables except Products. You can add the Product name and any other important Product information to the Orders table as a computed field, done.

    Remember, LightSwitch does not compute a computed field, until it is actually needed. Computed fields are not bad, only heavy computations are bad, and I think that showing the name for a Product, or the Product price in the Orders table is totally acceptable  because it is not a heavy computation.

     


    Make Them Ask: That's a LightSwitch App?

    http://LightSwitchHelpWebsite.com

    Monday, July 25, 2011 12:43 AM
  • Michael,

    The Killer App is LightSwitch!

    Monday, July 25, 2011 9:31 AM
  • Michael,

    The Killer App is LightSwitch!


    Well yes, you are correct :)

    Make Them Ask: That's a LightSwitch App?

    http://LightSwitchHelpWebsite.com

    Monday, July 25, 2011 12:53 PM
  • Those who created this project my congratulations
    Regardless of your method of marketing or price, in itself seems like a good product.
    Jaime
    Monday, July 25, 2011 1:29 PM
  • I am no expert in this field but whats the difference between this and excel pivot table? They look similar to me. Both have the filter, column field, row field and value. It just look the same to me. How much more powerfull is this feature than the excel pivot table?
    Tuesday, July 26, 2011 3:11 PM