topic SAP Orders and Material Movements with One mastercalendar. Is this possible?? in QlikView

SAP Orders and Material Movements with One mastercalendar. Is this possible??

Fri, 09 Jul 2010 16:07:48 GMT

Hello Guys,

I have two tables. One is Orders with a Fillerdate and the otherone is Materialmovements table with a Postingdate. As both tables contain Quantitites, I need to link these to different Calendars. As I want to show everything in Dashboard, it becomes difficult using two calendars. Is there a way to have only one Mastercalendar table and still get the connection right between the Materialmovements and Orders. I am attaching a Example. I would appreciate your replies.

Thanks and regards

Sravan

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/ExampleForum.qvw]

SAP Orders and Material Movements with One mastercalendar. Is this possible??

Fri, 09 Jul 2010 17:30:40 GMT

The fundamental question you need to ask yourself when approaching this question is: What is the date my user is selecting? If a user understands the process you're modeling, and they're presented with your calendar objects (the year, month, and week selection boxes) they should ask exactly the same question.

If I understand your question correctly, you're suggesting that you want only one master calendar that your users will select from. What do you expect that calendar to control? It can really only control one thing. So, if for your dashboard, only one of these two dates is important, then you can get away with using just one calendar (just don't create the other one). If they are both supposed to be selectable quantities (that require a master calendar) then, the short answer is, in my opinion, you can't.

Linking both objects through the same calendar would create a circular reference.

SAP Orders and Material Movements with One mastercalendar. Is this possible??

Mon, 12 Jul 2010 17:21:12 GMT

Hello Ryan,

Thanks for your answer. Normally a End-user dont understand the development part but what he would want is a dashboard, which at first shows all the values which he want to see. He will select in the dashboard the important things like Date, Plant, LIne and go further into the different sheets. He then see's the data in the other sheet which is wrong because of the selection in the Dashboard if the sheets are dependent on different Calendars. I have to realise different KPIs having different Dates. That means according to your answer, with only one date one can build a Dashboard. Otherwise it is not possible.

I thought there will be another way.

Thanks onceagain

Sravan

SAP Orders and Material Movements with One mastercalendar. Is this possible??

Mon, 12 Jul 2010 17:38:00 GMT

Hi Sravan,

He may not understand the development process, he doesn't have to. He only needs to provide clear requirements. I encounter this quite often, where people want to 'select THE date', as though there were only one. A perfectly reasonable question to ask regarding their requirements is: 'Which date?'

If you want just one date to control everything, you can create a single disconnected calendar, and use set analysis for everything. You'll need to be extremely careful, as selecting the same date range in two related objects with fundamentally different dates may not provide the results you expect. It may in fact be a contradiction to, for example, to show records where order filler date is between Jan 1 and 3^rd, and related material movements in the same date range.

SAP Orders and Material Movements with One mastercalendar. Is this possible??

Mon, 12 Jul 2010 17:42:55 GMT

Hi Ryan,

Ya as qlikview connects everything to everything and that is a big Advantage to have this interactive nature, where I can see for a Order the relative Material Movements. I dont think two dates gives the correct value in this Example. Thankyou and I got your point.

Regards
Sravan