Model definitions

I've inherited a database from a vendor. This database has primary keys defined but not any foreign keys to other tables. The vendor establishes all their relationships in their code.

I've created a simple model off of the base tables, but can only report on one table at a time which makes perfect sense. What is the best way to create a more usable model?

Create views with foreign keys defined and then use the views as my source for the dsv? or can I define relationships within the model itself? I have not been able to figure out how to add a foreign key in the model Can this be done?

1. Load your model into Model Designer.
2. Edit DSV - manually add foreign keys your tables
3. Regen the model - roles should automatically appear.

model db

Hello,
Question.. why would the model db transaction log be growing and getting ful
l? No new activity such as adding new databases or user defined data has occ
urred.
Thanks!!There's always some activity in the log, like checkpointing etc. Shouldn't b
e much but over a long time
perhaps...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> Hello,
> Question.. why would the model db transaction log be growing and getting full? No
new activity such as
adding new databases or user defined data has occurred.
> Thanks!!|||Hi,
As Tibor mentioned the growth will be very minimal, can you check the growth
by executing the below procedure during the growth situation
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OdP34WuXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> There's always some activity in the log, like checkpointing etc. Shouldn't
be much but over a long time
> perhaps...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
full? No new activity such as[vbcol=seagreen]
> adding new databases or user defined data has occurred.
>

model db

Hello,
Question.. why would the model db transaction log be growing and getting full? No new activity such as adding new databases or user defined data has occurred.
Thanks!!There's always some activity in the log, like checkpointing etc. Shouldn't be much but over a long time
perhaps...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> Hello,
> Question.. why would the model db transaction log be growing and getting full? No new activity such as
adding new databases or user defined data has occurred.
> Thanks!!|||Hi,
As Tibor mentioned the growth will be very minimal, can you check the growth
by executing the below procedure during the growth situation
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OdP34WuXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> There's always some activity in the log, like checkpointing etc. Shouldn't
be much but over a long time
> perhaps...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> > Hello,
> >
> > Question.. why would the model db transaction log be growing and getting
full? No new activity such as
> adding new databases or user defined data has occurred.
> >
> > Thanks!!
>

model db

Hello,
Question.. why would the model db transaction log be growing and getting full? No new activity such as adding new databases or user defined data has occurred.
Thanks!!
There's always some activity in the log, like checkpointing etc. Shouldn't be much but over a long time
perhaps...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
> Hello,
> Question.. why would the model db transaction log be growing and getting full? No new activity such as
adding new databases or user defined data has occurred.
> Thanks!!
|||Hi,
As Tibor mentioned the growth will be very minimal, can you check the growth
by executing the below procedure during the growth situation
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OdP34WuXEHA.1764@.TK2MSFTNGP10.phx.gbl...
> There's always some activity in the log, like checkpointing etc. Shouldn't
be much but over a long time[vbcol=seagreen]
> perhaps...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:601B4E8D-7FC8-40BD-B9CD-215260441284@.microsoft.com...
full? No new activity such as
> adding new databases or user defined data has occurred.
>
sql

Missing Value property of calculated member

Hi,

I defined several calculated measures in my cube. In Report Designer, i want to filter data depending a calculated measure.

Some caluclated measures are missing properties like value or ismissing. Anybody a hint, why these measures dont provide the properties, as for that filtering or hiding is not possible.

In AS every property is the sam for all calcs and the leaking calcs dont have difficult expressions (IIF(measure<0,measure/measure,0.0)

Thanks in advance

Please provide steps to repro this against the AdventureWorks sample cube.|||

Value property is working, even when it gets red underlined in visual studio.

So it works for me now.

Missing Value property of calculated member

Hi,

I defined several calculated measures in my cube. In Report Designer, i want to filter data depending a calculated measure.

Some caluclated measures are missing properties like value or ismissing. Anybody a hint, why these measures dont provide the properties, as for that filtering or hiding is not possible.

In AS every property is the sam for all calcs and the leaking calcs dont have difficult expressions (IIF(measure<0,measure/measure,0.0)

Thanks in advance

Please provide steps to repro this against the AdventureWorks sample cube.|||

Value property is working, even when it gets red underlined in visual studio.

So it works for me now.