One data load into dashboard with Binary link

[shyamcharan]

Hi Experts,

I have a dashboard that needs only day data, i.e. yesterday.

This dashboard and other dashboards are built using a QVW (in our case we call it as Data Model QVW).

Using the binary load, how can I limit the data into the dashboard for only one day?

I cannot limit the data into Data Model QVW as it is used in other dashboards that need who set of data.

Any suggestions or advises is highly helpful.

Thanks in advance

[Anil_Babu_Samineni]

I don't think so whether it can club and we have the option with Binary and Where condition at a time. Can you share more information such

1) Why this need from new qvw by helping of Binary

2) Is that customer asking you, If so what case they need to look

3) My assumption, Try this before load that qvw only using qvd and help of NoConcatenate.

[hector_munoz]

Hi Shyam,

You can not control binary load: you inherit tables, their data and their relations and after that you add new tables to the model or delete those that you donot need. So what you could do is creating a NO CONCATENATE fact table from the initial one with only the data you need (WHERE Date = (Today() - 1) and later dropping the original.

Hope it serves...

Regards,
H

[shyamcharan]

Hi Anil,

Thanks for your response.

It is how I designed the solution.

I wanted to have one central QVW with all the tables and data in it and build the dashboards using this main QVW(Datamodel or called Universe in terms of BUsiness objects)

This will have less maintenance and easy to use.

Yes, I will try NoConcatenate option. Thanks heaps.

[shyamcharan]

Thanks hector. Will try the NoConcatenate option

Thanks heaps.

[Anil_Babu_Samineni]

I may not understand this part. Yes, You have existing file and then you have one new qvw with the load of Existing qvw by help of Binary. And then finally you need one more qvw which instance with Where condition of one day. You meant to say

I am afraid, If there is option using binary load with where condition. May be they will help us

stevedark‌ mrkachhiaimp‌ stalwar1‌

[Anonymous]

Hi Shyam,

I don't think you can limit the data using the binary load. But additional to your binary load statement you can add resident load statements.

For example,

In binary load, if you are loading data from your 'Data Model QVW' then the tables(in your Data Model QVW) are created by default in your new QVW/Dashboard once the reload done. So further, you can filter on the table that is created using Resident load statement with the filter on date column (Today()-1).

To view the tables created use CTRL-T statement.

[stevedark]

Hi Shyam,

The binary load always takes the entire data model across.  This is one of the reasons why I do not use it.

You can drop tables from the new model once loaded, but it is far better not to bring in data you don't need.

Another method is to store all to QVD and then load all from QVD.

This code will do the store part;

//  Code to store all tables in a model to QVD

let iTabs = NoOfTables() -1;

for iTab = 0 to iTabs

       let vTab = TableName(iTab);

       STORE [$(vTab)] INTO [.\QVDOutput\$(vTab).qvd] (qvd);

next

for iTab = 0 to iTabs

       let vTab = TableName(0);

       DROP TABLE [$(vTab)];

next

And this code will then load all QVDs from the same folder:

// Code to load all QVDs from a table to the model

for each vQVD in FileList('.\QVDOutput\*.qvd')

       LOAD

              *

       FROM [$(vQVD)] (qvd);

next

On the load into the new app(s) you can then chose to pick which QVDs to load from, or add WHERE statements, rather than doing a loop and loading all data - should you require.

Hope that helps.

Steve