A user of one of my projects had developed a very nice view in Panorama Nova View 5.5 and we decided to integrate it into the views for all the users. So how do we take a view that was saved in a personal book of a user and add it to the general book in Panorama?
Well, first of all you take the user ID. Let's say it's "x123". You go to the Panorama Server and go to Program Files > Panorama > E - BI > Users > x123 > Private Book. You actually went to the physical folder that holds the user's views on his private book in Panorama. Copy the relevant view and paste it into you own Private Book (located also in Users folder, but obviously under your user ID).
Now, open Nova View Desktop. Connect to the relevant book, where you'd like to add the new view. When you connect to a book, the default is that you only see the web briefing book. You can add to that your own private book. Go in the top toolbar to Book > Show Private Book and click it.
You can now see your private book with the user's view. Right click it to copy it and then paste it into the Web Briefing Book. And that's how you can move your user's private view to Panorama's web briefing book without having to rebuild it.
A colleague of mine ran into a peculiar problem with her cube. She deployed it just fine and didn't get any error messages. Still, there was a problem. She could see the dimensions in her SSAS project just fine. She could see her cube as well. But she couldn't see any of her measure cubes.
So what was the problem? She was missing the calculate statement from her cube. If you look in the BIDS at your cube on the Calculations tab with a Script View, you'll be able to see that the first row in there is "Calculate;"
The calculate statement appears by default in the calculations tab of your cube. The calculate statement tell your cube to aggregate the fact data from the lowest level of granularity to the higher levels.
So, if you can't see any of your measure groups or all your measures return null value, then maybe you should check that the "Calculate;" statement exists in the Calculations tab in your cube.
Last but not least, I've recently learned that Dubi Lebel is leaving Microsoft Israel. Whenever I got to see Dubi, he would talk to me about something in SQL Server with the most genuine excitement. And his excitement is very contagious!
Dubi, I wish you the best of luck in your new path.