Showing posts with label describes. Show all posts
Showing posts with label describes. Show all posts

Sunday, March 11, 2012

Currency Conversions in ssas

Anyone got at link (other than books online) that describes how to implement currency conversions in ssas?

Here is some information for you

http://msdn2.microsoft.com/en-us/library/ms180174.aspx

http://msdn2.microsoft.com/en-us/library/ms175660.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Wednesday, March 7, 2012

Cube with more that one facts Table

Hello,

I made an illustration, that describes the szenario. There is one Master, one dimension and a second facts table. The Master Table holds up all objects. Sometimes I have additional Information for some objects in Master Table. They are stored in extra tables like the table Optional_facts_for_villas.

My question: How can I combine these two fact tables in Cube Designer without doing a Full outer Join in my Database?

The reason why I want it this way, not all optional_fact_tables are necessary now for OLAP, but maybe later. So, I thought, easiest way would be, adding them later to the cube, without changing the database.
Sorry for my english, its not the best :)

SilasYou forgot to mention which version of SQL Server you are using. As far as I remember this should be possible by using SQL Server 2005, but not SQL Server 2000.|||Ok, it's 2000. I think I will use the full outer join ;)