Hi Gurus,
i m new using IP, and now i got the next task, the client wants to save in BI a Marketing data tha they managed manually in excel, now the want to save this data in BI to centralize it and through a query, many of them can get the data, the first load will be trough an historic data flat file but, they want a way to modify some values after, and the idea we sold it, using IP, now thats the task.
I was thinking in this model but i need some advices, use a Standard cube to load the flat file with the marketing values until now, build a Real time Cube for IP, so, now i got 2 cubes, and i joint them in a multicube. so the input query will be created from the multicube, I DONT KNOW if this is possible, that the input query can modify values although the real time cube is empty but the standar cube has the data and this can be modified with the ip query, in summary, the input and output query would be created from the multicube with the standar cube with the data from the flat files, and the IP Cube that will be empty but as it is in the multicube, it will open the alternative to use IP to modify the values that stay in the standar cube, is this ok guys? some advices? help friends.