Assign default value for a dimension

Changing Default Keyboard

I installed swype but there is no place to switch default keyboard in the settings using the custom roms. Has anyone been able to do that?

Restoring 'Default' Android Icons

I'm currently using the SS ROM with the Apple style Icons and would like to use the default android icons instead. Is there a way of changing the icons after installation? Or can I do it within the script folder?

Audit dimension for a dimension?

The books describe how to create a useful audit dimension for the fact table rows, but what about the dimension table rows? Why isn't that mentioned in the books? Isn't the data quality and lineage also important for dimensions? Would you create a

How to assign color to individual's name?

I plan to commend members who contribute a lot to our newly-created forum by assigning colors to their names by hitting a certain number of post. Is that possible? Thanks

How to assign Special Ranks to members

How do I assign special ranks to members? I cannot find the 'edit user' button.

V1.911 - TV Show default selection

There is two parts to this request, first a bug & then a request..... Bug... I have the following TV Shows listed alphabetically (thanks for this bit).... Arrested Development Battlestar Galactica Battlestar Galactica (2003) Black

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Avatar by default to ALL users

Hello everybody!! Now, when we activate an avatar by default, for thouse users wich haven´t an avatar defined, this default avatar affects only to users wich register adter you activate this option, but not the other users wich were registred before, s

default profile setting

i would like to suggest that administrators be able to create a default profile setting to be applied to all new members. for example, default setting: Allow members to contact me by email : No Allow newsletters : Yes Can send Private Messages :

Bridge tables versus massive junk dimensions

I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

Dimension with two hierarchies

I need to design a dimension with two hierarchies 1. Location -> Building -> Room -> Cabin 2. Location ->Building I need the hierarchy 1 to be referenced in one FACT table and hierarchy 2 in other FACT. But my ETL tool allows only the dimension ke